203.
SELECT AVG(age) FROM STUDENT so‘rovi nimani qaytaradi
*STUDENTlarning o‘rtacha yoshini
204.
Quyidagi savol qanday javob qaytaradi SELECT * FROM students s, Groups g
* groups va students jadvalidagi dekart ko‘paytmani
chiqaradi
205.
Jadvaldagi qaydlar miqdori qanday hisoblanadi
* COUNT funksiyasi yordamida
206.
Agregat fuknsiyalarni ko`rsating
MIN, MAX,Count,AVG
207.
Qaysi operatorlar bilan MIN, MAX, AVG, SUM agregat funksiyalar bajarilishi mumkin
*faqatgina SELECT bilan
208.
MINUS operatori nimaga mo‘ljallangan
*Birinchi tanlovda mavjud, lekin ikkinchisida yo‘q
bo‘lgan natijalarni chiqarish uchun
209.
SELECT MAX(`mah_narxi(so``m)`) as `eng qimmat mahsulot` FROM `mahsulotlar`;
so`rov natijasini toping
Eng qimmat narxga ega bo`lgan mahsulot narxi
210.
SELECT * FROM `mahsulotlar` WHERE `mah_narxi(so``m)`(SELECT
MIN(`mah_narxi(so``m)`) FROM `mahsulotlar`); so`rov natijasini toping
Eng qimmat narxga ega bo`lgan mahsulot haqida
barcha ma`lumot
211.
select * from test order by ism desc; So`rovdagi "desc" nima vazifa bajaradi?
Ism ustunini teskarisiga saralaydi
212.
SELECT AVG(`mah_narxi(so``m)`) FROM `mahsulotlar`; so`rov natijasini toping
Mahsulotlar jadvalidagi mah_narxi ustunining o`rta
arifmetigi
213.
SELECT MID(`familiya`,1,1) FROM `xodimlar`; so`rov natijasini toping
Xodimlar familyalarining bosh harflarini chiqaradi
214.
a) SELECT MID(`familiya`,1,1) FROM `xodimlar`;b) SELECT LEFT(`familiya`,1)
FROM `xodimlar`; c) SELECT SUBSTR(`familiya`,1,1) FROM `xodimlar`; a, b va c
so`rovlarni farqini toping
farqi yo`q
Do'stlaringiz bilan baham: |