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