Mavzu: Having va group by standart so`zlaaridan foydalanib so`rov yaratish


Download 490.56 Kb.
bet1/3
Sana07.12.2019
Hajmi490.56 Kb.
  1   2   3

5-lobaratoriya ishi.
Mavzu: Having va GROUP BY standart so`zlaaridan foydalanib so`rov yaratish.
Bizning kafedra nomli ma`lumotlar bazamizda fan nomli jadval mavjud edi.
u quyidagicha:
select * from fan;

HAVING yordamida dars_soati 155 dan kichiklarini chiqaramiz.


select * from fan having dars_soati<155;




Do'stlaringiz bilan baham:
  1   2   3


Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2019
ma'muriyatiga murojaat qiling