Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- XAMPP
- SELECT AVG(Μισθός) FROM `εργαζομενοσ`
- SELECT ΚωδΤ,AVG(Μισθός)AS μεσοςμισθοςανατμημα FROM `εργαζομενοσ` GROUP BY ΚωδΤ
- SELECT ΚωδΤ,AVG(Μισθός)AS μεσοςμισθοςανατμημα FROM `εργαζομενοσ` GROUP BY ΚωδΤ HAVING AVG(Μισθός)>750
- SELECT ΌνομαΕ FROM `εργαζομενοσ` WHERE ΚωδΤ = 'Β-01'
- ATTENTION [ SELECT ΌνομαΕ FROM `εργαζομενοσ` WHERE ΚωδΤ = NULL //den t5ha vgalei kati alla galse gt kanena null den einai idio me ena allo null se mia database opote vazw (is) ]
- SELECT ΌνομαΕ FROM `εργαζομενοσ` WHERE ΚωδΤ is NULL
- EMFWLIASMENES ERWTHSEIS
- S
- F
- W ..... STHLH TELESTHS(S
- F
- W)
- SELECT ΚωδΤ FROM `τμημα` WHERE Τοποθεσία= 'Ισόγειο'
- ////////////////////////////////////////////////emganiste ta onomata twn ergazomenwn pou ergazontai sto isogeio
- SELECT ΌνομαΕ FROM ΕΡΓΑΖΟΜΕΝΟΣ WHERE ΚωδΤ IN( SELECT ΚωδΤ FROM ΤΜΗΜΑ WHERE Τοποθεσία= 'Ισόγειο')
- /////////////////////////////////////////////////onomasies tmhmatvn opou oi ergazomenoi exoun misthous anw twn 900
- SELECT Ονομασία
- FROM ΤΜΗΜΑ
- WHERE ΚωδΤ IN( SELECT ΚωδΤ
- FROM ΕΡΓΑΖΟΜΕΝΟΣ
- WHERE Μισθός >900)
- ///////////////////////////////////////////////vriskw ton ergazomeno me ton mikrotero mistho
- SELECT ΌνομαΕ
- FROM `εργαζομενοσ`
- WHERE Μισθός = (SELECT MIN(Μισθός)
- FROM ΕΡΓΑΖΟΜΕΝΟΣ
- )
- MPORW NA TO LUSW KAI ME -ALL- ME EMFWLEUSH
- ASKHSEIS
- 1)ONOMATA ERG POU EXOUN MISTHO MEGALYTERO APO KATHE ERG TOU TMHMATOS B-02
- 2)ONOMA TMHMATOS POY PLHRWNEI TON MEGALYTERO MISTHO
- /////////////////////////////////////////////////////KARTESIANO GINOMENO METAKSU PINAKWN KAI EPILEGEI TA KOINA GIA NA FIAKSEI NEO PINAKA
- SELECT * FROM `εργαζομενοσ` NATURAL INNER JOIN ΤΜΗΜΑ
- /////////////////////////////////////////////////EMFANIZEI KAI TA MH KOINA TOY ARISTEROY PINAKA ALLA ME NULLS+GRAMMES POY DEN ENONONTAI DLD
- SELECT * FROM `εργαζομενοσ` NATURAL LEFT OUTER JOIN ΤΜΗΜΑ
- MPORW NA VALW KAI RIGHT OUTER JOIN
Add Comment
Please, Sign In to add comment