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


Download 249.34 Kb.
bet3/3
Sana19.06.2023
Hajmi249.34 Kb.
#1619281
1   2   3
Bog'liq
4-Amaliy ish

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

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

Natija:

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





  1. 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:


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

Download 249.34 Kb.

Do'stlaringiz bilan baham:
1   2   3




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling