Malumotlar bazasi fanidan Amaliy ish 2
Narziyeva Gulshon mb amaliy
- Bu sahifa navigatsiya:
- Toshkent 2023 Use database sorovi orqali ozimizga kerakli bazani tanlab olamiz Use kafedra;
- Select * from fanlar where soati 120 and 60; buyrugi orqali soati 120 va 60 soat bolgan fanlarni olamiz
- 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 oqituvchilar where Yoshi in (30,33,40); buyrugi Yoshi 30 , 33 , 40 ga teng bolgan oqituvchilarni korsatadi
- Select * from talabalar where FISH like ‘%K%’; buyrugi talabalar FISH ida K harfi qatnashganlarini olib chiqadi
- Select * from talabalar group by FISH having id = 4 ; buyrugi FISH boyicha guruxlab id si 4ga teng bolagnini chiqarib beradi
Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling
ma'muriyatiga murojaat qiling