Bajardi: 610-19 guruh talabasi Abdullayev Faxriddin Qabul qildi

Bajardi:	610-19 guruh talabasi Abdullayev Faxriddin
Qabul qildi:	A. Dilshodov, M.Burxonova

8-9 Laboratoriya ishlari

Mavzu: Group by va Order by standart so’zlaridan foydalanib so’rov yaratish. HAVING standart so’zidan foydalanib so’rov yaratish.

Nazariy qism.

ORDER BY kalit so'zidan natijani o'sish yoki kamayish tartibida tartiblash uchun

foydalaniladi va sukut bo'yicha yozuvlarni o'sish tartibida tartiblaydi.

Sintaksis ORDER BY

SELECT column1, column2, ...

FROM table_name

ORDER BY column1, column2, ... ASC/DESC;

GROUP BY iborasi ko'pincha natijalarni bir yoki bir nechta ustunlarga guruhlash

uchun agregat funktsiyalaridan (COUNT, MAX, MIN, SUM, AVG)

foydalaniladi.

Sintaksis GROUP BY

SELECT column_name(s)

FROM table_name

WHERE condition

GROUP BY column_name(s).

1-jadaval Mashina obyektining hususiyatlari (MOH)




Order by standart so’zining qo’llanishi:

SELECT 1-ustun, 2-ustun, ...

FROM Jadval_nomi

ORDER BY 1-ustun, 2-ustun, ... ASC|DESC;

1-misol: 1-jadvaldagi ma’lumotlarni Order BY standart so’zida foydalanib Mashina_turi ustunidagi ma’lumotlar asosida tartiblab yozish.

mysql> Select * from moh

-> Order BY Mashina_turi desc;

Natija

Grpoup By standart so’zining qo’llanishi:

SELECT Ustun_nomi(s)

FROM Jadval_nomi

WHERE amal

GROUP BY Ustun_nomi(s)

ORDER BY Ustun_nomi(s);

2-Misol: 1-jadvaldagi ma’lumotlarni Group BY operatori yordamida Mashina_turi ustunigi ma’lumotlar orqali guruxlash;

mysql> Select Raqami,Egasi, Mashina_turi

-> From moh

-> Group BY Mashina_turi;

Natija

3-Misol: Endi yuqoridagi jadvalvaldagi Egasi ustunini alfavit bo’yicha saralaymiz;

mysql> Select * from moh

-> Group by Egasi

-> Order by Egasi asc;

Natija

Having operatorining qo’llanishi

SELECT 1-ustun, 2-ustun,…

FROM Jadval_nomi

WHERE amal

GROUP BY 1-ustun, 2-ustun,…

HAVING amal

ORDER BY 1-ustun, 2-ustun,…;

4-Misol: 1-jadvaldagi ma’lumotlarni 5-Tartib_raqamigacha bo’lganlarini Egasi ustunidagi ma’lumotlarni alfavit tartibida saralab chiqarish.

mysql> select * from moh

-> Having Tartib_raqami<5

-> Order By Egasi asc;