SELECT n select SELECT ALLDISTINCT table expression alias
SELECT n Η γενική σύνταξη της select SELECT [ ALL/DISTINCT ] { [table. ] * / expression [ alias ], . . . } FROM table [ alias ] [, table [ alias ] ]. . . [WHERE condition] [GROUP BY expr [, expr]. . . [HAVING condition] ] [ORDER BY expr [ASC/DESC] [, expr [ASC/DESC] ]. . . ] [ { UNION / INTERSECT / MINUS } query ] ; 14/2/2022 3 1. 3 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
SELECT * from TEACHERS; 14/2/2022 24 1. 24 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
SELECT TFNAME, TLNAME, SCHOOL FROM TEACHERS; 14/2/2022 25 1. 25 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
SELECT DISTINCT EIDIKOTHTA FROM TEACHERS; 14/2/2022 26 1. 26 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
SELECT UCODE, UNAME FROM UNIVERSITIES WHERE LOCATION='ΑΤΤΙΚΗ'; 14/2/2022 27 1. 27 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
SELECT * FROM TEACHERS, COURSES WHERE COURSES. CTYPE='Π'; 14/2/2022 28 1. 28 ΓΕΩΡΓΙΑΔΗΣ ΖΑΦΕΙΡΗΣ
- Slides: 28