Tassos

Sql 14-1-15

Jan 14th, 2015
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.73 KB | None | 0 0
  1.     {                                       http://g-lts.info/                                                }
  2.  
  3. SELECT * FROM ENIKIAZOMENA;
  4.  
  5.  
  6. SELECT KODIKOS_AUTOKINITOU FROM AUTOKINITA WHERE KODIKOS_AUTOKINITOU NOT IN ( SELECT KODIKOS_AUTOKINITOU FROM ENIKIAZOMENA );
  7.  
  8.  
  9. SELECT KODIKOS_AUTOKINITOU,COUNT(*) FROM ENIKIAZOMENA GROUP BY KODIKOS_AUTOKINITOU HAVING COUNT(*) >= ALL (SELECT COUNT(*) FROM ENIKIAZOMENA GROUP BY KODIKOS_AUTOKINITOU);
  10.  
  11.  
  12. SELECT * FROM PELATES WHERE KODIKOS_PELATI = ( SELECT KODIKOS_PELATI FROM ENIKIAZOMENA WHERE POSO_PLIROMIS = ( SELECT MAX(POSO_PLIROMIS) FROM ENIKIAZOMENA ) ) ;
  13.  
  14.  
  15.  
  16.  
  17.     {                                       http://g-lts.info/                                                }
Advertisement
Add Comment
Please, Sign In to add comment