1. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha and, or



Yüklə 116,79 Kb.
Pdf görüntüsü
səhifə1/6
tarix02.12.2022
ölçüsü116,79 Kb.
#72007
  1   2   3   4   5   6
2 deadline kif



2-dedline topshiriqlari 
1. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha AND, OR, 
NOT operatorlaridan foydalanib so’rovlar yaratishi va natijasi bilan 
ko’rsatib o’tishi kerak.
 
mysql> SELECT * FROM xodimlar WHERE `ishga_kirgan_yil`=2017 AND `maosh`=2000000;
+----------+-----------+--------------+------------------+---------+---------+------------------+
| xodim_id | ism | familiya | ishga_kirgan_yil | maosh | lavozim | ish vaqti (soat) |
+----------+-----------+--------------+------------------+---------+---------+------------------+
| 6 | Shukurullo | Abdulhamidov | 2017 | 2000000 | mexanik | 8 |
| 7 | Nosirjon | Mahamadjonov | 2017 | 2000000 | mexanik | 8 |
+----------+-----------+--------------+------------------+---------+---------+------------------+ 2 
rows in set (0.00 sec)
mysql> SELECT * FROM xodimlar WHERE `ishga_kirgan_yil`=2017 OR `maosh`=2000000;
+----------+-------------+--------------+------------------+---------+--------------------+------------------+
| xodim_id | ism | familiya | ishga_kirgan_yil | maosh | lavozim | ish vaqti (soat) |
+----------+-------------+--------------+------------------+---------+--------------------+------------------+
| 1 | Islomjon | Ismoilov | 2017 | 5000000 | direktor | 8 |
| 2 | Otabek | Tursunov | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 3 | Asror | Nosiraliyev | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 4 | Behzod | Keldiyev | 2017 | 2200000 | ishchi xodim | 8 |
| 5 | Abdulla | Komilov | 2017 | 2200000 | ishchi xodim | 8 |
| 6 | Shukurullo | Abdulhamidov | 2017 | 2000000 | mexanik | 8 |
| 7 | Nosirjon | Mahamadjonov | 2017 | 2000000 | mexanik | 8 |
| 8 | Muhammadrizo | Rayimjonov | 2017 | 3000000 | nazoratchi | 8 |
+----------+-------------+--------------+------------------+---------+--------------------+------------------+
8 rows in set (0.00 sec)
mysql> SELECT * FROM xodimlar WHERE NOT `maosh`=2000000;


+----------+-------------+-------------+------------------+---------+--------------------+------------------+
| xodim_id | ism | familiya | ishga_kirgan_yil | maosh | lavozim | ish vaqti (soat) |
+----------+-------------+-------------+------------------+---------+--------------------+------------------+
| 1 | Islomjon | Ismoilov | 2017 | 5000000 | direktor | 8 |
| 2 | Otabek | Tursunov | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 3 | Asrorjon | Nosiraliyev | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 4 | Behzod | Keldiyev | 2017 | 2200000 | ishchi xodim | 8 |
| 5 | Abdulla | Komilov | 2017 | 2200000 | ishchi xodim | 8 |
| 8 | Muhammadrizo | Rayimjonov | 2017 | 3000000 | nazoratchi | 8 |
+----------+-------------+-------------+------------------+---------+--------------------+------------------+ 6 
rows in set (0.00 sec)

Yüklə 116,79 Kb.

Dostları ilə paylaş:
  1   2   3   4   5   6




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azkurs.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin