9. 10,11- laboratoriya ishlari asosida Standart funksiyalardan foydalanib so‘rovlar yaratish

Lpad ('', , '').

So`rov: Select LPAD(FISH,5,‟mayda‟) as newarea from Xodim;

Natija:

6. 
   Rpad ('', , '').
   

So`rov:Select RPAD (FISh,3,‟may‟) as qisqartirma from Xodim;

Natija:

7. 
   Length (''), octet_length ('')
   

So`rov: select Length(FISh) from Xodim;

Natija:

8. 
   LTRIM, RTRIM - Satrning chap va ong tomonidagi probellarni olish.
   

So`rov: Select id, FISH, vazifasi, LTRM(vazifasi), RTRM(vazifasi) from Xodim;

Natija:

9. 
   LEFT(qator,miqdor) – qatorning chap tomonidan, ko‘rsatilgan miqdordagi belgilarni qaytaradi.
   

So`rov: Select Left(FISh,5) as FISH from Xodim;

Natija:

10. 
    RIGHT(qator, miqdor) - qatorning o‘ng tomonidan, ko‘rsatilgan miqdordagi belgilarni qaytaradi;
    

So`rov: Select Right(FISh, 4) as FISh from Xodim;

Natija:

Predmet soha ma`lumotlar bazasi

shakllantirilgandan so`ng ob`yektlardagi ma`lumotlarni guruhli

agregat funktsiyalar orqali ishlash.