6-10 labaratoriya ishlari Bajardi: Yoqubjonov Azizbek Guruh: 241-21 Tekshirdi: Sodiqov Valijon toshkent – 2023

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: