Kommunikatsiyalarini rivojlantirish vazirligi muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti tt-fakulteti

Ma’lumotlarni tanlash va ular ustida amallar.

SELECT * FROM xodimlar ORDER BY F_I_Sh

SELECT * FROM xodimlar ORDER BY F_I_Sh

SELECT * FROM samalyot WHERE Rusumi = 'AN-22' OR Yolovchi_sigimi=200

SELECT * FROM samalyot WHERE Rusumi BETWEEN 'AN-22' AND 'AN-76'

SELECT sum(Yolovchilar_soni) AS Umumiy_Yolovchilar_soni FROM reyslar

ALTER TABLE samalyot add column Yaroqlilik_muddati varchar(15)

UPDATE samalyot SET Yaroqlilik_muddati = '25 yil' WHERE ID = 1

Mohiyat – aloqa diagrammasi (ER modeli).

Mavzu: SQL yordamida Where standart so‘zidan foydalanish.
Ishdan maqsadni, talaba o’zi belgilaydi ya’ni bajarmoqchi bo’lgan ishidan kelib chiqib.
Topshiriqlar:
1. AND, OR, NOT mantiqiy stanndart so‘zlardan foydalanish.
2. Where standart so‘zidan foydalanish(, ==, !=, between, like).
3. Group by va Order by HAVING standart so‘zlardan foydalanish.
Javoblar:
1. AND, OR, NOT mantiqiy stanndart so‘zlardan foydalanish.
AND

OR

NOT

2. Where standart so‘zidan foydalanish(, ==, !=, between, like).

< >

< = >=
!=

Between

Like

3. Group by va Order by HAVING standart so‘zlardan foydalanish.

Group by

HAVING

Order by

Xulosa:
Xulosa qilib aytamanki bu topshiriqni bajarish davomid AND, OR NOT operatorlaridan qanaqa qilib foydalanishni ham bizga nima uchun kerakligini o’rgandim.

2 va 3 – chi topshiriqlarni bajarib esa ma’lumotlarni filterlashni ya’ni (saralashni o’rgandim) unda asosan WHERE, LIKE, BETWEEN, GROUP BY VA ORDER BY, HAVING buyruqlari orqali sql surovlar yozdim