• 1.11 Select ID, log(ID) from futbolchilar;
  • I s h d an m aq s ad
  • U s l u b iy k o`rsat m a l a r
  • MySQL Syntax: SELECT column_name(s) FROM table_name WHERE condition LIMIT number ; Oracle Syntax
  • Select ID, FISH, round(ID/staji, 3) from xodimlar




    Download 3,3 Mb.
    bet15/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

    Select ID, FISH, round(ID/staji, 3) from xodimlar;

    1.7

    select ID, maoshi, power(ID, maoshi) from murabbiy;

    1.8

    1/9

    Select vazn, sqrt(vazn) from futbolchilar;


    1.10 Select ID, sin(ID) from murabbiy;

    1.11 Select ID, log(ID) from futbolchilar;




    1.12Select * from murabbiy where ID between 1 and 3;


    1.13 Select mid(FISH,1,1) as 'bosh harflar', FISH frommurabbiy;


    11 – Amaliy mashg’ulot
    Mavzu: Murakkab so‘rovlar yaratish. TOP, LIMIT yoki ROWNUM

    Ishdan maqsad: Berilgan predmet soha ma`lumotlar bazasidan foydalanib TOP, LIMIT yoki ROWNUM lardan foydalanishni o`rganish.
    Masalani qo`yilishi: Predmet soha ma`lumotlar bazasi shakllantirilgandan so`ng undan unumli foydalanishni tashkil etish maqsadida TOP, LIMIT yoki ROWNUM lar orqali so`rovlar yaratish.
    Uslubiy ko`rsatmalar: SQL LIMIT va SQL TOP operatorlarining vazifasi belgilangan satrlarni chaqirishdan iborat. SQL TOP operatori MS SQL Serverda ishlaydi, SQL LIMIT operatori esa MySQLda va Oracle da ROWNUM operatori ishlaydi ularnig vazifasi bir hil.
    SQL Server / MS Access Syntax:
    SELECT TOP number|percent column_name(s)
    FROM table_name
    WHERE condition;
    MySQL Syntax:
    SELECT column_name(s)
    FROM table_name
    WHERE condition
    LIMIT number;
    Oracle Syntax:
    SELECT column_name(s)
    FROM table_name
    WHERE ROWNUM <= number;

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




    Download 3,3 Mb.

    Bosh sahifa
    Aloqalar

        Bosh sahifa



    Select ID, FISH, round(ID/staji, 3) from xodimlar

    Download 3,3 Mb.