004. ORDER BY, LIMIT, OFFSET, DISTINCT

Bu mavzuda tartiblash, sahifalash va takrorlarni olib tashlash bo'yicha 30 ta masala bor. Har bir masala oldida qavs ichida sxema nomi va qiyinlik darajasi ko'rsatilgan. Sxemalar Sxemalar va tayyorlov sahifasida berilgan.

Masalani o'zingiz yechib, natijani Kutilgan natija bilan solishtiring. O'zgartiruvchi masalalarda (INSERT, UPDATE, DELETE, DDL) natija shartda aytilgan tekshiruv so'rovidan olingan. Natija 10 qatordan ko'p bo'lsa, birinchi 10 qator ko'rsatilgan.

1. (dokon, oson) Mahsulotlarni narx bo'yicha o'sish tartibida (nom, narx) chiqaring; narx teng bo'lsa id bo'yicha.

Kutilgan natija

Telefon 1 | 12900.00
Noutbuk 2 | 20800.00
Futbolka 3 | 28700.00
Jinsi 4 | 36600.00
Non 5 | 44500.00
Sut 6 | 52500.00
Roman 7 | 60400.00
Lugat 8 | 68300.00
Choynak 9 | 76200.00
Stul 10 | 84100.00

2. (dokon, oson) Mahsulotlarni narx bo'yicha kamayish tartibida (id, narx) chiqaring.

Kutilgan natija

25 | 202900.00
24 | 195000.00
23 | 187100.00
22 | 179200.00
21 | 171200.00
20 | 163300.00
19 | 155400.00
18 | 147500.00
17 | 139600.00
16 | 131700.00

3. (dokon, oson) Eng qimmat 5 ta mahsulot nomi va narxini chiqaring.

Kutilgan natija

Non 25 | 202900.00
Jinsi 24 | 195000.00
Futbolka 23 | 187100.00
Noutbuk 22 | 179200.00
Telefon 21 | 171200.00

4. (dokon, oson) Eng arzon 3 ta mahsulotni (id, narx) chiqaring.

Kutilgan natija

1 | 12900.00
2 | 20800.00
3 | 28700.00

5. (dokon, oson) Mijozlar yashaydigan noyob shaharlarni alifbo tartibida chiqaring.

Kutilgan natija

Andijon
Buxoro
Fargona
Namangan
Samarqand
Toshkent

6. (dokon, oson) Buyurtma holatlarining noyob ro'yxatini chiqaring.

Kutilgan natija

bekor
yangi
yetkazildi

7. (dokon, oson) To'lov usullarining noyob ro'yxatini chiqaring.

Kutilgan natija

click
karta
naqd

8. (dokon, o'rta) Eng so'nggi 5 ta buyurtmani (id, sana) chiqaring.

Kutilgan natija

60 | 2024-10-27
59 | 2024-10-22
58 | 2024-10-17
57 | 2024-10-12
56 | 2024-10-07

9. (dokon, o'rta) Mahsulotlarni narx bo'yicha kamayish tartibida tartiblab, 3-o'rindan boshlab 5 tasini (OFFSET 2) chiqaring.

Kutilgan natija

23 | Futbolka 23 | 187100.00
22 | Noutbuk 22 | 179200.00
21 | Telefon 21 | 171200.00
20 | Stul 20 | 163300.00
19 | Choynak 19 | 155400.00

10. (soni, o'rta) (shahar, tugilgan_yil) juftliklarining noyob sonini soni sifatida chiqaring.

Kutilgan natija

30

11. (dokon, o'rta) Mijozlarni shahar bo'yicha alifbo tartibida, shahar ichida ism bo'yicha tartiblab chiqaring (id, shahar, ism).

Kutilgan natija

3 | Andijon | Dilnoza Aliyev
15 | Andijon | Jasur Karimov
27 | Andijon | Nargiza Tursunov
21 | Andijon | Vali Rahimova
9 | Andijon | Zilola Yusupova
20 | Buxoro | Ali Karimov
26 | Buxoro | Bekzod Rahimova
14 | Buxoro | Madina Yusupova
8 | Buxoro | Otabek Aliyev
2 | Buxoro | Sardor Tursunov

12. (maktab, oson) O'quvchilarni tug'ilgan sanasi bo'yicha eng kattadan boshlab 5 tasini chiqaring (ism, tugilgan).

Kutilgan natija

Doniyor Ergashev | 2008-02-20
Madina Karimova | 2008-02-21
Sevara Karimova | 2008-03-28
Sherzod Ismoilov | 2008-03-29
Timur Ismoilov | 2008-05-04

13. (maktab, oson) O'qituvchilarni maosh bo'yicha kamayish tartibida (ism, maosh) chiqaring.

Kutilgan natija

Anvar Qodirov | 6000000.00
Feruza Nazarov | 5750000.00
Rustam Saidova | 5500000.00
Malika Qodirov | 5250000.00
Shuhrat Nazarov | 5000000.00
Gulnora Saidova | 4750000.00
Anvar Qodirov | 4500000.00
Feruza Nazarov | 4250000.00
Rustam Saidova | 4000000.00
Malika Qodirov | 3750000.00

14. (maktab, oson) Baholarda uchraydigan noyob ballarni kamayish tartibida chiqaring.

Kutilgan natija

5
4
3
2
1

15. (maktab, o'rta) Eng yuqori maosh oluvchi 3 o'qituvchining ismini chiqaring.

Kutilgan natija

Anvar Qodirov
Feruza Nazarov
Rustam Saidova

16. (maktab, o'rta) Davomat holatlarining noyob ro'yxatini chiqaring.

Kutilgan natija

kasal
keldi
kelmadi

17. (bank, oson) Balansi eng katta 5 ta hisobni (id, balans) chiqaring.

Kutilgan natija

40 | 49382680.00
39 | 48148113.00
38 | 46913546.00
37 | 45678979.00
36 | 44444412.00

18. (bank, oson) Filiallar shaharlarining noyob ro'yxatini chiqaring.

Kutilgan natija

Andijon
Buxoro
Samarqand
Toshkent

19. (bank, oson) Hisob turlarining noyob ro'yxatini chiqaring.

Kutilgan natija

depozit
jamgarma
joriy

20. (bank, o'rta) Eng katta 3 ta qarzni (id, summa) chiqaring.

Kutilgan natija

19 | 62000000.00
18 | 59000000.00
17 | 56000000.00

21. (bank, o'rta) Tranzaksiyalardan 11-chisidan boshlab 5 tasini sana bo'yicha tartiblab chiqaring (id, sana).

Kutilgan natija

11 | 2024-01-09 04:00:00
12 | 2024-01-09 21:00:00
13 | 2024-01-10 14:00:00
14 | 2024-01-11 07:00:00
15 | 2024-01-12 00:00:00

22. (bank, o'rta) Qarzlarni holat bo'yicha, so'ng summa kamayish tartibida chiqaring (id, holat, summa).

Kutilgan natija

18 | faol | 59000000.00
15 | faol | 50000000.00
12 | faol | 41000000.00
9 | faol | 32000000.00
6 | faol | 23000000.00
3 | faol | 14000000.00
17 | kechikkan | 56000000.00
14 | kechikkan | 47000000.00
11 | kechikkan | 38000000.00
8 | kechikkan | 29000000.00

23. (kutubxona, oson) Eng yangi 5 ta kitobni (nom, yil) chiqaring.

Kutilgan natija

Kitob 33 yoli | 2021
Kitob 13 yoli | 2020
Kitob 26 kuni | 2017
Kitob 6 kuni | 2016
Kitob 39 dunyosi | 2014

24. (kutubxona, oson) Kitob nashr yillarining noyob ro'yxatini birinchi 10 tasini o'sish tartibida chiqaring.

Kutilgan natija

1951
1952
1954
1955
1958
1959
1961
1962
1965
1966

25. (kutubxona, oson) Mualliflar davlatlarining noyob ro'yxatini chiqaring.

Kutilgan natija

Angliya
Ozbekiston
Rossiya

26. (kutubxona, o'rta) Mualliflarni tug'ilgan yili bo'yicha eng kattadan boshlab 2-sahifa (har sahifada 3 ta) ni chiqaring.

Kutilgan natija

Cholpon | 1897
Oybek | 1905
Pirimqul Qodirov | 1928

27. (kutubxona, o'rta) Ijaralarni olingan sanasi bo'yicha kamayish tartibida birinchi 5 tasini chiqaring (id, olingan).

Kutilgan natija

70 | 2024-10-07
69 | 2024-10-03
68 | 2024-09-29
67 | 2024-09-25
66 | 2024-09-21

28. (dokon, qiyin) Har bir shahardan faqat bitta (id si eng kichik) mijozni chiqarish uchun DISTINCT ON ishlating (shahar, id, ism).

Kutilgan natija

Andijon | 3 | Dilnoza Aliyev
Buxoro | 2 | Sardor Tursunov
Fargona | 5 | Jasur Karimov
Namangan | 4 | Madina Yusupova
Samarqand | 1 | Vali Rahimova
Toshkent | 6 | Bekzod Rahimova

29. (bank, qiyin) Har bir mijozning eng katta balansli hisobini DISTINCT ON bilan chiqaring (mijoz_id, id, balans).

Kutilgan natija

1 | 40 | 49382680.00
4 | 31 | 38271577.00
7 | 32 | 39506144.00
10 | 33 | 40740711.00
13 | 34 | 41975278.00
16 | 35 | 43209845.00
19 | 36 | 44444412.00
22 | 37 | 45678979.00
25 | 38 | 46913546.00
28 | 39 | 48148113.00

30. (kutubxona, qiyin) Har bir janrdagi eng yangi kitobni DISTINCT ON bilan chiqaring (janr_id, id, yil).

Kutilgan natija

1 | 25 | 2006
2 | 26 | 2017
3 | 32 | 2010
4 | 33 | 2021
5 | 39 | 2014