Diskda saqlanadigan fayllar katologi


Download 51.82 Kb.
bet7/43
Sana05.01.2022
Hajmi51.82 Kb.
#219212
1   2   3   4   5   6   7   8   9   10   ...   43
Malumotlar bazasi
b) Buyruqlarni avtomatik bajarish
c) Ma’lumotlarni kiritish va ko’rish
d) Ma’lumotlarni saqlash
#17==============================================================
Quyidagi SQL so’rovi natijasi nimani ko’rsatadi:
SELECT Name,max (baho) FROM talaba INNER JOIN imtihon ON talaba.id_s=imtihon.id_s
GROUP BY FIO;
a) Talabaning olgan baholarini korsatadi
b) Har bir talaba olgan max balni korsatadi
c) Eng yuqori ball olgan talabaning ismini korsatadi
d) Eng past baho olgan talabaning ismi va bahosini korsatdi
#18===============================================================
SELECT * FROM Talaba Where Yoshi > (SELECT yoshi FROM Talaba Where Name=’Bahodir’)
a) Bahodir ismli talabalarning ichida Yoshi kattasini

Download 51.82 Kb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7   8   9   10   ...   43




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