Sql 14-1-15

    {                                       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/                                                }