Bog'liq malumotlar bazasini boshqarish tizimi fanidan laboratoriya ishlari
5.4 rasm. 4 misoldagi so`rovning natijasi
Nazorat savollari 1. SQL tilida HAVING kalit so`zining strukturasi qanday?
2. SQL tilida GROUP BY kalit so`zining strukturasi qanday?
3. HAVING kalit so`zidan qanday maqsadlarda foydalaniladi?
4. HAVING va WHERE kalit so`zlarining vazifalarini farqlab bering.
5. HAVING kalit so`zi qanday agregat funksiyalar bilan qo`llanilishi
mumkin?
6. GROUP BY kalit so`zidan qanday maqsadlarda foydalaniladi?
7. GROUP BY kalit so`zi ORDER BY dan nimasi bilan faq qiladi?
8. GROUP BY kalit so`zidan foydalanib biron bir so`rov yarating.
9. HAVING kalit so`zidan foydalanib biron bir so`rov yarating.
10.HAVING va GROUP BY kalit so`zlaridan foydalanib so`rov yarating.