💻 Informatika va dasturlash · Ma'lumotlar bazasi va SQL · ★★★
talaba(ism, shahar) jadvalida: (Ali, Toshkent), (Vali, Samarqand), (Gani, Toshkent), (Lola, Buxoro), (Nodira, Samarqand), (Said, Toshkent). Ushbu so'rov natijasida nechta qator chiqadi? SELECT shahar, COUNT(*) FROM talaba GROUP BY shahar HAVING COUNT(*) > 1;
- A)6
- B)1
- C)3
- D)2
👀 To'g'ri javob va tushuntirishni ko'rish
✓ D) 2
💡 Guruhlar: Toshkent 3, Samarqand 2, Buxoro 1; HAVING faqat birinchi ikkitasini qoldiradi.