|
Select Subj_name, max (hour)
From
|
| bet | 19/53 | | Sana | 16.12.2023 | | Hajmi | 6,79 Mb. | | #120080 |
Select Subj_name, max (hour)
From SUBJECT;
Group by Subj_name
Having max (Hour)>= 34;
Ishni bajarish tartibi
1. Zavoddan bir kunlik olinadigan maxsulotlarning 5000 kgdan kam ishlab chiqarilganlari haqida ma`lumot berilsin:
So’rov: Select *from maxsulot having ogirligi_kg<5000;
Natija:
6.5 – rasm. Having kalit so’zining qo‘llanilishi
Ikki va undan maxsulot ishlaydigan qurilmalar chiqarilsin;
So‘rov: Select korpus_id as ‘2 tadan kop maxsulot ishlab chiqaradigan korpuslar id lari’ , count(maxsulot_nomi) as ‘maxsulotlar soni’ from maxsulot group by korpus_id having count(maxsulot_nomi)>=2;
Natija:
6.6. – rasm. Group by va Having kalit so’zlarining qo’llanilishi
Vazifalar
Yuqorida ko`rsatilganlardan foydalanib tanlangan variyantga muvofiq mavzu uchun MySQL da order by ,group by , Having buyruqlari bilan ishlang.
Bajarilgan ishlar haqida hisobot tayyorlang (1-2-ilovalarga qarang).
Nazorat savollari
SQL tilida GROUP BY kalit so‘zining strukturasi qanday?
SQL tilida ORDER BY kalit so‘zining strukturasi qanday?
GROUP BY kalit so‘zidan qanday maqsadlarda foydalaniladi?
ORDER BY kalit so‘zidan qanday maqsadlarda foydalaniladi?
GROUP BY kalit so‘zi ORDER BY dan nimasi bilan faq qiladi?
SQL tilida HAVING kalit so‘zining strukturasi qanday?
HAVING kalit so‘zidan qanday maqsadlarda foydalaniladi?
7 -Amaliy ish. UNION, INTERSECT va MINUS standart so‘zlaridan foydalanish
|
| |
