• L E FT( q ato r , m i q d or)
  • UPPER( q at o r)
  • Select sum(maoshi) as maoshlari yegindis from murabbiy; 1.1 1.2 Select avg(id) as orta arifmetiki from murabbiy;
  • Select max(maoshi) as eng kotta maosh from futbolchilar; 1.6 1.7 Select ID, FISH, rand(ID) from futbolchilar;
    		•

    Zafar-mb-7-8 pdf




    Download 3,3 Mb.
    bet14/17
    Sana14.05.2024
    Hajmi3,3 Mb.
    #232380
    1   ...   9   10   11   12   13   14   15   16   17
    Bog'liq
    qayta o\'qish mb7-12

    LOG(son) – sonning natural logarifmini hisoblaydi; Qatorlar bilan ishlash funksiyalari:
    LEN(qator) – qatordagi belgilar sonini hisoblaydi;
    LTRIM(qator) – qator boshidagi bo’sh joylar (probel)larni o’chiradi; RTLIM(qator) - qator oxiridagi bo’sh joylar (probel)larni o’chiradi; LEFT(qator,miqdor) – qatorning chap tomonidan, ko’rsatilgan miqdordagi belgilarni qaytaradi;
    RIGHT(qator, miqdor) - qatorning o’ng tomonidan, ko’rsatilganmiqdordagi belgilrni qaytaradi;
    LOWER(qator) – ko’rsatilgan qator belgilarini kichik harflarga o’tkazadi;
    UPPER(qator) - ko’rsatilgan qator belgilarini katta harflarga o’tkazadi; STR(son) – son qiymatini belgi formatiga konvertirlashni amalga oshiradi;
    SUBSTRING(qator,indeks, uzunlik) – qator uchun ko’rsatilgan uzunlikdagi qator qismini, aniqlashtirilgan indeksdan boshlab qaytaradi.

    Select sum(maoshi) as 'maoshlari yegindis' from murabbiy;
    1.1


    1.2 Select avg(id) as 'orta arifmetiki' from murabbiy;


    1.3 Select min(ish_staj) as 'eng kam ish_staj' from murabbiy;

    1.4


    1.,5 select ID, max(ish_staj) from group by ID;



    Select max(maoshi) as 'eng kotta maosh' from futbolchilar;

    1.6

    1.7 Select ID, FISH, rand(ID) from futbolchilar;



    Download 3,3 Mb.
    1   ...   9   10   11   12   13   14   15   16   17




    Download 3,3 Mb.