Bajardi: Norkulov Kamol Guruh: 10-21 toshkent – 2022 laboratoriya ishi mavzu: Ma’lumotlarni saralash. Where standart so‘zidan foydalanish

Natija:


So’rov: select UPPER(FISH) from bolimlar;
Natija:



So’rov: select LPAD(FISH,4, ‘sayd) as newarea from bolimlar;
Natija:


So’rov: select RPAD(FISH,4,’$’) as newarea from bolimlar;
Natija:



So’rov:select LEFT(nomi,3) as nomi from bolimlar;
Natija:



So’rov: select right(nomi,5 ) as nomi from bolimlar;
Natija:

So’rov: select LENGTH(nomi) from bolimlar;
Natija: