622-21 guruh talabasi Shermuxammedov Abdurahim
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.
select*from 777_APTEKA where ID='1 ' And ( Lavozimi='Sotuvchi');
+------+-------------------+----------+
| id | xodim_FIO | lavozimi |
+------+-------------------+----------+
| 1 | Esanmurodov Abbos | sotuvchi |
select*from 777_APTEKA where ID='1 ' And NOT ( Lavozimi='Sotuvchi');
Empty set (0.00 sec)
2. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha WHERE,
IN, BETWEEN, LIKE operatorlaridan foydalanib so’rovlar yaratishi va
natijasi bilan ko’rsatib o’tishi kerak.
select*from 777_APTEKA where LAVOZIMI= 'SOTUVCHI';
+------+-------------------+----------+
| id | xodim_FIO | lavozimi |
+------+-------------------+----------+
| 1 | Esanmurodov Abbos | sotuvchi |
| 2 | Zoirov Qobiljon | sotuvchi |
SELECT * FROM 777_APTEKA
-> WHERE LAVOZIMI IN ('SOTUVCHI' );
+------+-------------------+----------+
| id | xodim_FIO | lavozimi |
+------+-------------------+----------+
| 1 | Esanmurodov Abbos | sotuvchi |
| 2 | Zoirov Qobiljon | sotuvchi |
SELECT * FROM 777_APTEKA
-> where XODIM_FIO Between 1 And 3;
+------+----------------------+-------------+
| id | xodim_FIO | lavozimi |
+------+----------------------+-------------+
| 1 | Esanmurodov Abbos | sotuvchi |
Dostları ilə paylaş: |