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 |
