O’zbekiston Respublikasi
Raqamli Texnologiyalar
Vazirligi Muhammad Al-
Xorazmiy nomidagi Toshkent
Axborot Texnologiyalari
Universiteti Farg’ona filiali
Sirtqi bo’lim
3-bosqich 712-21-guruh
Kampyuter injinerng
Anvarov Asadullo
Ma’lumotlar bazasi
fanidan tayyorlagan
3-Amaliy ishi
Topshirdi:
Anvarov Asadullo
Qabul qildi:
Dilshodov A
Bir nechta jadvallar birlashtirish, “JOIN” lar bilan
ishlash. Murakkab so’rovlar yaratish
mysql>
select
x.xodim_familiyasi,
x.kutubxonasi,
x.lavozimi,
x.ishga_kirgan_yili from xodimlar x
-> inner join kutubxona k
-> on k.id_k=x.id_x;
+------------------+-------------+--------------+-------------------+
| xodim_familiyasi | kutubxonasi | lavozimi | ishga_kirgan_yili |
+------------------+-------------+--------------+-------------------+
| Ergashev | TATU 1-ARM | Mudir | 2021 |
| Turgunov | TATU 2-ARM |Kutubxonachi | 2019 |
| Shokarimov | TATU 3-ARM |Kutubxonachi | 2011 |
| Sobirov | TATU 4-ARM |oqituvchi | 2011 |
| Komilov | TATU 2-ARM |oqituvchi | 2011 |
| Ergashev | TATU 2-ARM |rektor | 2019 |
| Dilshodov | TATU 1-ARM |tuiter | 2019 |
+------------------+-------------+--------------+-------------------+
7 rows in set (0.06 sec)
mysql>
select
x.xodim_familiyasi,
x.kutubxonasi,
x.lavozimi,
x.ishga_kirgan_yili, k.shahar from xodimlar x
-> inner join kutubxona k
-> on k.id_k=x.id_x;
+------------------+-------------+--------------+-------------------+----------+
| xodim_familiyasi | kutubxonasi | lavozimi | ishga_kirgan_yili | shahar |
+------------------+-------------+--------------+-------------------+----------+
| Ergashev | TATU 1-ARM | Mudir | 2021 | Fergana |
| Turgunov | TATU 2-ARM |Kutubxonachi | 2019 | Fergana |
| Shokarimov | TATU 3-ARM |Kutubxonachi | 2011 | Fergana |
| Sobirov | TATU 4-ARM |oqituvchi | 2011 | Fergana |
| Komilov | TATU 2-ARM |oqituvchi | 2011 | Fergana |
| Ergashev | TATU 2-ARM |rektor | 2019 | Toshkent |
| Dilshodov | TATU 1-ARM |tuiter | 2019 | Toshkent |
+------------------+-------------+--------------+-------------------+----------+
7 rows in set (0.00 sec)
mysql>
select
x.xodim_familiyasi,
x.kutubxonasi,
x.lavozimi,
x.ishga_kirgan_yili, k.shahar, k.manzil, x.maoshi from xodimlar x
-> inner join kutubxona k
-> on k.id_k=x.id_x;
+------------------+-------------+--------------+-------------------+----------+--------
--------------+--------+
| xodim_familiyasi | kutubxonasi | lavozimi | ishga_kirgan_yili | shahar |
manzil | maoshi |
+------------------+-------------+--------------+-------------------+----------+--------
--------------+--------+
| Ergashev | TATU 1-ARM | Mudir | 2021 | Fergana |
A_Navoiykocha 2-uy | 3 mln |
| Turgunov | TATU 2-ARM |Kutubxonachi | 2019 | Fergana |
Qodiriykocha 2-uy | 3 mln |
| Shokarimov | TATU 3-ARM |Kutubxonachi | 2011 | Fergana |
Yaxshilikkocha 2-uy | 3 mln |
| Sobirov | TATU 4-ARM |oqituvchi | 2011 | Fergana |
A_Navoiykocha 2-uy | 2 mln |
| Komilov | TATU 2-ARM |oqituvchi | 2011 | Fergana |
A_Navoiykocha 3-uy | 2 mln |
| Ergashev | TATU 2-ARM |rektor | 2019 | Toshkent |
Beruniykocha 1-uy | 2 mln |
| Dilshodov | TATU 1-ARM |tuiter | 2019 | Toshkent |
Beruniykocha 1-uy | 2 mln |
+------------------+-------------+--------------+-------------------+----------+--------
--------------+--------+
7 rows in set (0.00 sec)
Dostları ilə paylaş: |