3-Mavzu. Sql – tilida so’rovlar. Reja

SELECT id_talaba, familiya, ismi, sharifi, tug_yil
FROM talaba
WHERE tug_yil=1989 OR tug_yil=1990;
Toshkent yoki Samarqand shahridan kelgan va millati o`zbek bo`lgan talabalarni ro`yxati chiqarilsin.
SELECT id_talaba, familiya, ismi, sharifi,
tug_shahar
FROM talaba
WHERE (tug_shahar=`Toshkent` or tug_shahar=`Samarqand`) and millati=`o`zbek`;
b) interval predikatini ishlatish.
1980 yildan 1994-yilgacha tug`ilgan talabalarni ro`yxati chiqarilsin
1- variant.
SELECT id_talaba, familiya,ismi, sharifi, tug_yil
FROM talaba
WHERE tug_yil>=1980 AND tug_yil<=1994;
2- variant.
SELECT id_talaba, familiya,ismi, sharifi, tug_yil
FROM talaba
WHERE tug_yil BETWEEN 1980 AND 1994;
c) To`plamga kirish predikatini ishlatish.
Toshkent, Samarqand, Buxoro, Andijon, Urganch, Qarshi shaharlardan
kelgan talabalar ro`yxati chiqarilsin.
SELECT id_talaba, familiya, ismi, sharifi, tug_shahar
FROM talaba
WHERE tug_shahar IN (`Toshkent`, `Samarqand`,
`Buxoro`, `Andijon`, `Urganch`, `Qarshi`);
Toshkent va Samarqand shaharlardan tashqari kelgan talabalar
ro`yxatini chiqarish.
SELECT id_talaba, familiya, ismi, sharifi, tug_shahar
FROM talaba
WHERE tug_shahar NOT IN
(`Toshkent`,`Samarqand`);
Bizga qo`shimcha jadval berilgan bo`lsin:
shaharlar(id_shahar, shahar_nomi, vil_nomi)
Toshkent viloyatidagi shaharlardan kelgan talabalar ro`yxati chiqarilsin.
SELECT id_talaba, familiya, ismi, sharifi, tug_shahar
FROM talaba
WHERE tug_shahar IN (SELECT shahar_nomi
FROM shaharlar
WHERE vil_nomi=`Toshkent viloyati`);
Bu misolda shaharlar to`plami so`rov qism orqali berilgan.
d) Qolip predikatini ishlatish.
Familiyasi birinchi harfi «A» uchinchisi «b» bo`lgan talabalarni ro`yxati chiqarilsin