Malumotlar bazasi fanidan Amaliy ish 2

MUHAMMAD AL-XORAZMIY NOMIDAGI
TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI



malumotlar bazasi fanidan
Amaliy ish 2
240-21 guruh talabasi
Bajardi: Narziyeva Gulshon
Tekshirdi:Jurayev T.


Toshkent 2023



Use database sorovi orqali ozimizga kerakli bazani tanlab olamiz
Use kafedra;





Select * from tableName; sorovi orqali jadvallarni korib olamiz




Select * from fanlar where soati 120 and 60; buyrugi orqali soati 120 va 60 soat bolgan fanlarni olamiz


Select * from where fanlar where soati = 120 or krediti = 4 ; buyrugi bizga soati 120ga teng bolganlar yoki krediti 4 bolgan fanlarni olib keladi



Select * from talabalar where Yoshi >=25 and talim_turi = ‘kechki’; buyrugi talabalar jadvalidan Yoshi 25dan katta bolgan talabalar ichidan talim turi kechki bolganini korsatadi





Select * from talabalar where Yoshi !=20; buyrugi Yoshi 20ga teng bolgan talabalarni chiqarib bermaydi


Select * from oqituvchilar where Yoshi in (30,33,40); buyrugi Yoshi 30 , 33 , 40 ga teng bolgan oqituvchilarni korsatadi


Select * from fanlar where krediti between 2 and 4; buyrugi krediti 2 va 4 bolganlar fanlarni keltirib beradi 2 bn 4 ham kiradi


Select * from talabalar where FISH like ‘%K%’; buyrugi talabalar FISH ida K harfi qatnashganlarini olib chiqadi



Select * from fanlar order by nomi; buyrugi fanlarni nomi boyicha alifbo tartibida chiqaradi


Select * from oqituvchilar group by familiyasi; buyrugi oqituvchilarni familiyasi boyicha guruxlab chiqaradi


Select * from talabalar group by FISH having id = 4 ; buyrugi FISH boyicha guruxlab id si 4ga teng bolagnini chiqarib beradi