Guruh Talabasi Mo’ydinova Zeboxon ning Laboratoriya ishi Mavzu

711-19_Guruh Talabasi

Mo’ydinova Zeboxon ning

4.1 .Laboratoriya ishi

Mavzu: Group by va Order by standart so’zlaridan foydalanib so’rov yaratish. Ishdan maqsad: Group by va Order by standart so’zilaridan foydalanish bo`yicha ko`nikmaga ega bo`lish.

Masalani qo`yilishi: Berilgan predmet soha ma`lumotlar bazasidagi barcha ob`yektlarni ustida tartiblash amallarini bajarish.

Uslubiy ko`rsatmalar:

SQL – ORDER BY kalit so'z ORDER BY kalit so'zidan natijani o'sish yoki kamayish tartibida tartiblash uchun foydalaniladi va sukut bo'yicha yozuvlarni o'sish tartibida tartiblaydi. Yozuvlarni kamayish tartibida tartiblash uchun DESC kalit so'zidan foydalaning. Ko'tarilish tartibida tartiblash uchun ASC kalit so'zidan foydalaning.

mysql> show databases;

+-----------------------------+ | Database |

+-----------------------------+

| information_schema |

| dengiz_axborot_tizimi |

| mb_sayyohlik_firmasi |

| mysql |

| palekklinika_axborot_tizimi |

| paleklinika_axborot_tizimi |

| paleklinika_axborot_tizimmi |

| shop |

| test |

+-----------------------------+

9 rows in set (0.00 sec)

mysql> show tables;

+--------------------------------+

| Tables_in_mb_sayyohlik_firmasi |

+--------------------------------+

| ekskursiyalar_jadval |

| guruh_tarkibi |

| jadval_guruh |

| turistlar_jadval |

+--------------------------------+

4 rows in set (0.06 sec)

1. Order by

2.GROUP BY

mysql> select safari from guruh_tarkibi;

+-----------+

| safari |

+-----------+

| Toshkent |

| Samarqand |

| Buxoro |

| Xorazm |

| Namangan |

| Namangan |

| Namangan |

| Namangan |

| Andijon |

| Andijon |

| Andijon |

| Toshkent |

| Toshkent |

| Xorazm |

| Xorazm |

| Buxoro |

| Buxoro |

| Buxoro |

| Fargona |

+-----------+

19 rows in set (0.00 sec)

3 .having