4 laboratoriya ishi mavzu: Like operatori, Having, group by operatori Bakhramov Abdufaiz Ishni bajarish tartibi

Natija:
5.2-rasm. Substr va mantiqiy amallarning qo’llanishi

3. 
   So`rov: SELECT FISH, length(lavozimi), manzili, oyligi FROM zavod_xodimlari WHERE NOT xodim_id=3;
   

Natija:

3. – rasm. Length funksiyasi va NOT mantiqiy amalining qo’llanishi

4. 
   Zavod xodimlarining ism, familiyasini LOWER yordamida kichik harflarda, manzilining uzunligi va IDsi 1 va 2 oralig’idagi xodimlarni chiqaramiz:
   

So`rov: SELECT xodim_id, Lower(FISH), manzili, length(manzili), oyligi
FROM zavod_xodimlari WHERE xodim_id BETWEEN 1 and 2;


Natija:

3. 
   – rasm. Lower, length funksiyalari va Between mantiqiy amalining qo’llanishi