Texnologiyalari universiteti telekommunikatsiyalar fakulteti

select first_name, count(*) from student group by first_name 
order by first_name; 
 
 
 
 
 
 
 
 
 
 
So’rovi : 
select * from student order by first_name; 

---

 
 
So’rovi : 
select * from student order by first_name desc; 
 
 
So’rovi :
select * from student having last_name = 'bahromov'; 
 
 
 
 
 
 
 
So’rovi : 
select first_name , count(*) from student group by first_name 

---

having count(*)>2;
 
 
 
 

---

Document Outline

• 5 - AMALIY MASHG‘ULOTI
• Mavzu: Ma’lumotlarni saralash. Where standart so‘zidan foydalanish
• 6 - AMALIY MASHG‘ULOTI
• Mavzu: Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish. Having standart so‘zi orqali so‘rovlar yaratish