Mavzu: Standart so‘zlaridan foydalanish. Standart funksiyalardan foydalanib so‘rovlar yaratish. Agrеgat funksiyalardan foydalanish. Ishdan maqsad: lower, upper, rpad, replace, ucase, reverse, format, initcap, lpad, rpad, length, ltrim, left

Download 269,66 Kb.
Sana	07.12.2023
Hajmi	269,66 Kb.
	#113354

Bog'liq
MB 4-topshiriq

Ishdan maqsad: LOWER, UPPER, RPAD, REPLACE, UCASE, REVERSE, FORMAT, INITCAP, LPAD, RPAD, LENGTH, LTRIM, LEFT, RIGHT

O’ZBEKISTON RESPUBLIKASI AXBOROT TEXNOLOGIYA-LARI VA KOMMUNIKATSIYALARINI RIJOJLANTIRISH VAZIRLIGI MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI
Ma’lumotlar bazasi fani bo’yicha

Amaliy ish-4

Bajardi:DBM-004 guruh talabasi
Abdumannonov Arslonbek
Tekshirdi: Djurayev Tulkinjon

Mavzu: Standart so‘zlaridan foydalanish. Standart funksiyalardan foydalanib so‘rovlar yaratish. Agrеgat funksiyalardan foydalanish.

Ishdan maqsad: LOWER, UPPER, RPAD, REPLACE, UCASE, REVERSE, FORMAT, INITCAP, LPAD, RPAD, LENGTH, LTRIM, LEFT, RIGHT Funksiyalaridan foydalanish, agregat funksiyalaridan foydalanishni o`rganish.

mysql> use kutubxona;
mysql> show tables ;

mysql> select * from xodim;

mysql> select upper(lavozim) from xodim;

mysql> select lower(FISH) from xodim;

mysql> select rpad(id,10,ID) from obunachi;

m ysql> select rpad(id,10,"_id") from obunachi;

mysql> select nomi as name ,replace(nomi,'fizika','falsafa') from kitob;

mysql> select Kitob_turlari ,reverse('ilmiy') from rasta ;

mysql> select reverse('tabiiy'),reverse('ilmiy') from rasta ;

mysql> select ltrim(FISH) from xodim;

mysql> select rtrim(lavozim) from xodim;

mysql> select rpad(Nomi,20,'*') from rasta;

mysql> select lpad(Nomi,20,'*') from rasta;

mysql> select FISH as ism_Familya from xodim where length(FISH)>18;

mysql> select right(lavozim,3),lavozim from xodim order by lavozim limit 3;

mysql> select left(lavozim,4),lavozim from xodim order by lavozim limit 4;

E’TIBORINGIZ UCHUN RAXMAT!!!

Download 269,66 Kb.