Tassos icon

Sql 14-1-15

Tassos | PRO | 01/14/15 08:34:24 AM UTC | 0 ⭐ | 494 👁️ | Never ⏰ | []
MySQL |

730 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
    {                                       http://g-lts.info/                                                }
 
SELECT * FROM ENIKIAZOMENA;
 
 
SELECT KODIKOS_AUTOKINITOU FROM AUTOKINITA WHERE KODIKOS_AUTOKINITOU NOT IN ( SELECT KODIKOS_AUTOKINITOU FROM ENIKIAZOMENA );
 
 
SELECT KODIKOS_AUTOKINITOU,COUNT(*) FROM ENIKIAZOMENA GROUP BY KODIKOS_AUTOKINITOU HAVING COUNT(*) >= ALL (SELECT COUNT(*) FROM ENIKIAZOMENA GROUP BY KODIKOS_AUTOKINITOU);
 
 
SELECT * FROM PELATES WHERE KODIKOS_PELATI = ( SELECT KODIKOS_PELATI FROM ENIKIAZOMENA WHERE POSO_PLIROMIS = ( SELECT MAX(POSO_PLIROMIS) FROM ENIKIAZOMENA ) ) ;
 
 
 
 
    {                                       http://g-lts.info/                                                }

Comments