laboratoriya ishi

PPTX 22 pages 4.7 MB Free download

22 pages

FaylHub.uz

Download via Telegram

Size 4.7 MB

File type PPTX

Pages 22

Updated Dec 2025

Page preview (5 pages)

Scroll down 👇

1 / 22

prezentatsiya powerpoint muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti 2 – bosqich dbm002-guruh talabasi toshpulatov jasurbekning “ma’lumotlar bazasi” fanidan bajargan 2- mustaqil ishi 5 - laboratoriya ishi mavzu: and, or, not mantiqiy standart so‘zlardan foydalanish ishdan maqsad: talabalarda and, or, not mantiqiy stanndart so‘zlardan foydalanish va shu orqali relyatsion mb da ishlash ko’nikmasini hosil qilish. ishni bajarish tartibi oyligi 4 000 000 dan ko’p yoki id 2 dan katta xodimlar idsini, fishini lavozimini esa katta harflarda chiqaramiz; sport kompleks xodimlar jadvallarini ko’ramiz; so`rov: select *from ticket; natija: 5.1-rasm. ticket jadvalidagi ma’lumotlarni ko’rish 5.2-rasm. substr va mantiqiy amallarning qo’llanishi 5.3– rasm. not mantiqiy amalining qo’llanishi 5.4– rasm. between mantiqiy amalining qo’llanishi 6 - laboratoriya ishi mavzu: ma’lumotlarni saralash. where standart so‘zidan foydalanish ishdan maqsad: ma`lumotlar bazasiga so`rovlar tizimini yaratish, saralash va where standart so`zidan foydalanishni o`rganish va ko`nikmaga ega bo`lish ishni bajarish 1.avvalgi laboratoriyada yaratgan bazamizning jadvallarini ko’ramiz; so`rov: show tables; …

2 / 22

nilishi order by kalit so’zining desc bilan qo’llanilishi 8 - laboratoriya ishi mavzu: having standart so‘zi orqali so‘rovlar yaratish ishdan maqsad: berilgan predmet soha ma`lumotlar bazasidan foydalanib having standart so`zidan foydalanishni o`rganish. masalani qo`yilishi: predmet soha ma`lumotlar bazasi shakllantirilgandan so`ng undan unumli foydalanishni tashkil etish maqsadida having standart so`zlaridan foydalanib so`rovlar yaratish. ma`lumotlar bazasidan kerakli ma`lumotlarni yuqoridagi standart so`z orqali ajratib olishni tashkil etish. uslubiy ko`rsatmalar: having parametri qator guruhlari uchun tanlov shartini belgilashga imkon beradi. u where parametriga o'xshaydi, lekin group by parametridan keyin aniqlanadi va birlashtirilgan qatorlarga qo'llaniladi. having parametrini tanlash shartida, so'rov bo'yicha ustunlar qiymatlarini, shu jumladan agregat funktsiyalarining qiymatlarini ishlatishingiz mumkin. ishni bajarish tartibi having kalit so’zining qo’llanilishi image6.png image7.png image8.png image9.png image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image20.png image21.png image2.png image3.png image4.png image5.png mariadb [airways_company]> select * from ticket; dsss sits sidr se de dt do sss bprs pst sss tpes …

3 / 22

$, ticket_status, cost_ofticket, number_ofseat from ticket -> where cost_ofticket > 25@ and number ofseat_> 100; +-- seana ss -+- | ticket_id | ticket_status }\ cost_ofticket | number: 7 | middle | 1@ | middle cel ! cheap 3 rows in set (@.0@2 sec) mariadb [airways_company]> select ticket_id, ticket_status, cost_ofticket, number_ofseat from ticket -> where ticket_id in(1,2,3,4,5,6,7) and not ticke’ confort simple comfort middle middle middle 6 rows in set (0.000 sec) mariadb [airways _company]> select ticket id, ticket_status, cost_ofticket, number_ofseat from ticket -> where number_ofseat[{between 10 and 250; | ticket_id | ticket_status ! i + - +-- | 5s | middle | | | 6 | middle | 240 | i 7 | middle | 328 i i} 1@ | middle | 320 | i} 12 | cheap | 220 | $----------- too 22222-2222 $oneo nnn n nen $--------sssesss s rows in set (@.0@1 sec) mariadb [airways_company]> show tables; a …$

4 / 22

name | varchar(3@) | yes | | null | | | fromwhere | varchar(3@) | yes | | null | | | to_where | varchar(3@) | yes | | null | | | gone_time | int(4) | | null | | | count_time | int(4) tgyes aa | | null | | $-------------- $-------------, $------ +----- $--------- 4$---------------- + 6 rows in set (@.0@5 sec) mariadb [airways_company]> desc ticket; $--------------- 4-22---------- $------ +----- 4$--------- $---------------- + | field | type | null | key | default | extra | -+ | ticket_id | int(a1) | no | pri | null | auto_increment | | ticket_status | varchar(3@) | yes | | null | | | cost_ofticket | varchar(5) | yes | | null | | | type_ofpay | varchar(1@) | yes | | null | | | number_ofseat | int(4) | yes | | null | | - es ss …

5 / 22

ts’ from ticket; 1 row in set (@.0@3 sec) mariadb [airways_company]> select avg(cost_ofticket) as ‘arithmetic mean’ from ticket; 1 row in set (@.001 sec) mariadb [airways company]> select ticket_id, sum(cost_ofticket) as “umumiy narx” from ticket; i to + | ticket_id | umumiy narx | | a] 3560 | = 1 row in set (0.007 sec) mariadb [airways_company]> select ticket_id, sum(cost_ofticket) as “umumiy narx” from ticket group by ticket_id; i to | ticket_id | umumiy narx | 200 | 250 | 320 | 310 | 220 | 240 | 320 | 420 | 360 | 320 | 380 | | 220 | a to + 12 rows in set (0.002 sec) be soavoueunr u mariadb [airways _company]> select * from ticket order by ticket_status; 5 one = = | ticket_id | ticket_status | cost_ofticket | type_ofpay | number_ofseat 12 uu confort, middle middle middle middle simple fr nvsuoraony é 12 rows …

Want to read more?

Download all 22 pages for free via Telegram.

Download full file

About "laboratoriya ishi"

prezentatsiya powerpoint muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti 2 – bosqich dbm002-guruh talabasi toshpulatov jasurbekning “ma’lumotlar bazasi” fanidan bajargan 2- mustaqil ishi 5 - laboratoriya ishi mavzu: and, or, not mantiqiy standart so‘zlardan foydalanish ishdan maqsad: talabalarda and, or, not mantiqiy stanndart so‘zlardan foydalanish va shu orqali relyatsion mb da ishlash ko’nikmasini hosil qilish. ishni bajarish tartibi oyligi 4 000 000 dan ko’p yoki id 2 dan katta xodimlar idsini, fishini lavozimini esa katta harflarda chiqaramiz; sport kompleks xodimlar jadvallarini ko’ramiz; so`rov: select *from ticket; natija: 5.1-rasm. ticket jadvalidagi ma’lumotlarni ko’rish 5.2-rasm. substr va mantiqiy amallarning qo’llanishi 5.3– rasm. not mantiqiy amali...

This file contains 22 pages in PPTX format (4.7 MB). To download "laboratoriya ishi", click the Telegram button on the left.

Tags: laboratoriya ishi PPTX 22 pages Free download Telegram