Lalmikor Ekologiya va atrof muhit ishlara 16 10000000SELECT *FROM zavod_xodimlari MINUS SELECT *SELECT kon_xodimlari;Eshbotayev Sardor Lalmikor Tegirmon mashinisti 10Labaratoriya mu 15 90000007000000 5 Muhammadiyev Begzod Olmali Kon_xodimlariN az o r at sa v ol l ari8 - Amaliy ishi .bir nеchta jadvallar birlashtirish, joinlar bilan ishlash I s h d an m aq s adINNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, FULL OUTER JOIN va ONSELECT column_names [,... n] FROM Table_1 INNER JOIN Table_2 ON conditionSELECT column_names [,... n] FROM Table_1 LEFT JOIN Table_2 ON conditionSELECT column_names [,... n] FROM Table_1 RIGHT JOIN Table_2 ON conditionSELECT column_names [,... n] FROM Table_1 CROSS JOIN Table_2So‘rov : SELECT column_names [,... n] Table_1 FULL JOIN Table_2 ON conditionSo‘rov: SELECT *FROM zavod_xodimlari INNER JOIN kon_xodimlari ON zavod_xodimlari.FISH=kon_xodimlari.FISH; NatijaON zavod_xodimlari.manzili = kon_xodimlari.manzili; |
So`rov:
SELECT *FROM zavod_xodimlari
|
| bet | 23/53 | | Sana | 16.12.2023 | | Hajmi | 6,79 Mb. | | #120080 |
Bu sahifa navigatsiya:
- Lalmikor Ekologiya va atrof muhit ishlara 16 10000000
- SELECT *FROM zavod_xodimlari MINUS SELECT *SELECT kon_xodimlari;
- Eshbotayev Sardor Lalmikor Tegirmon mashinisti 10
- Labaratoriya mu 15 9000000
- 7000000 5 Muhammadiyev Begzod Olmali
- Kon_xodimlari
- N az o r at sa v ol l ari
- 8 - Amaliy ishi .bir nеchta jadvallar birlashtirish, joinlar bilan ishlash I s h d an m aq s ad
- INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, FULL OUTER JOIN va ON
- SELECT column_names [,... n] FROM Table_1 INNER JOIN Table_2 ON condition
- SELECT column_names [,... n] FROM Table_1 LEFT JOIN Table_2 ON condition
- SELECT column_names [,... n] FROM Table_1 RIGHT JOIN Table_2 ON condition
- SELECT column_names [,... n] FROM Table_1 CROSS JOIN Table_2
- So‘rov : SELECT column_names [,... n] Table_1 FULL JOIN Table_2 ON condition
- So‘rov: SELECT *FROM zavod_xodimlari INNER JOIN kon_xodimlari ON zavod_xodimlari.FISH=kon_xodimlari.FISH; Natija
- ON zavod_xodimlari.manzili = kon_xodimlari.manzili;
So`rov:
SELECT *FROM zavod_xodimlari
INTERSECT
SELECT *FROM kon_xodimlari;
Natija:
Xodim_
id
|
FISH
|
manzili
|
lavozimi
|
Ish_staji
|
Oyligi
|
3
|
Nazrullayev Oybek
|
Lalmikor
|
Boyitish ishlari menejeri
|
15
|
10000000
|
6
|
Duvlonov Bunyod
|
Lalmikor
|
Ekologiya va atrof muhit ishlara
|
16
|
10000000
|
7
|
Shobotayev Shahzod
|
Oqtosh
|
Loyihalash ishlari muhandisi
|
14
|
9000000
|
7.8 – rasm. Zavod_xodimlari va Kon_xodimlari jadvallarini Inresect operatori qo’llanilishi natijasi
5. MINUS yordamida 1-jadvalimizdan ikkinchisini ayirish amalini bajaramiz:
SELECT *FROM zavod_xodimlari
MINUS
SELECT *SELECT kon_xodimlari;
Natija:
Xodim_id
|
FISH
|
Manzili
|
Lavozimi
|
Ish_staji
|
Oyligi
|
1
|
Eshbotayev Sardor
|
Lalmikor
|
Tegirmon mashinisti
|
10
|
7000000
|
2
|
Abirov Dilshod
|
Marjonbuloq
|
Labaratoriya mu
|
15
|
9000000
|
4
|
Soliyev Elmurod
|
Marjonbuloq
|
Xavsizlik ishlari
|
10
|
7000000
|
5
|
Muhammadiyev Begzod
|
Olmali
|
Gruz mashinisti
|
12
|
8000000
|
7.9– rasm. Zavod_xodimlari va Kon_xodimlari jadvallarini Inresect operatori qo’llanilishi natijasi
Vazifalar
Yuqorida ko‘rsatilganlardan foydalanib tanlangan variantga muvofiq mavzu uchun MySQL da union, intersect va minus standart so‘zlari bilan ishlang.
Bajarilgan ishlar haqida hisobot tayyorlang (1-2-ilovalarga qarang).
Nazorat savollari
UNION standart so‘zi nima maqsadda foydalaniladi?
MINUS standart so‘zi qanday hollarda qo`llaniladi?
INTERSECT standart so‘zi nima maqsadda foydalaniladi?
UNIONning qanday ko‘rinishlari mavjud?
MBda birlashtirish nima?
MBda qo`shish amali qaysi standart so‘zi bilan qo`llaniladi?
MBda ayirish amali deganda nima tushuniladi?
Standart so‘zlarning qo‘llanish sintaksisini ko‘rsating.
UNION ALL standart so`zining UNIONdan farqi nimada?
8 - Amaliy ishi .bir nеchta jadvallar birlashtirish, joinlar bilan ishlash
Ishdan maqsad: Berilgan predmet soha ma`lumotlar bazasidan foydalanib, bir nеchta jadvallar birlashtirish, JOINlar bilan ishlash.
Masalani qo`yilishi: Predmet soha ma`lumotlar bazasi shakllantirilgandan so`ng ob`yektlardagi ma`lumotlarni birlashtirish maqsadida INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, FULL OUTER JOIN va ON standart so`zlaridan foydalanish. Barcha ob`yektlardagi ma`lumotlarni yuqoridagi standart so`zlar orqali birlashtiradigan so`rovlar tashkil etish.
Uslubiy ko`rsatmalar: Agar select operatorida from so‘zidan keyin 1 ta jadval emas 2 ta jadval ishlatilsa, bunda so‘rovni natija tashkil qiluvchi jadval 1 jadvali xar bir satri bilan 2-jadvalni xar bir satriga ulashdan (kombinatsiyadan) yaratiladi. Bu amal jadvallarni birlashtirish deyiladi.
SQL INNER JOIN operatorining 1-2 jadvalning mos elementlarini qo‘shadi.
SQL INNER JOIN operatorining sintaksisi quyidagi ko‘rinishda bo‘ladi:
-
|
SELECT_column_names_[,..._n]_FROM_Table_1_LEFT_JOIN_Table_2_ON_condition'>SELECT_column_names_[,..._n]_FROM_Table_1_INNER_JOIN_Table_2_ON_condition'>SELECT
column_names [,... n]
FROM
Table_1 INNER JOIN Table_2
ON condition
|
8.1 – rasm. Inner join operatorining Venn diagrammasi orqali ko‘rinishi
SQL LEFT JOIN operatorining 1 jadval va 2 jadvalning 1 jadvalda mos elementlarini qo‘shadi.
SQL LEFT JOIN operatorining sintaksisi quyidagi ko‘rinishda bo‘ladi:
-
|
SELECT
column_names [,... n]
FROM
Table_1 LEFT JOIN Table_2
ON condition
|
8.2 – rasm. Left outer join operatorining Venn diagrammasi orqali ko’rinishi
SQL RIGHT JOIN operatorining 2 jadval va 1 jadvalning 2 jadvalda mos elementlarini qo`shadi.
SQL RIGHT JOIN operatorining sintaksisi quyidagi ko`rinishda bo`ladi:
-
|
SELECT
column_names [,... n]
FROM
Table_1 RIGHT JOIN Table_2 ON condition
|
8.3– rasm. Right outer join operatorining Venn diagraamsi orqali ko’rinishi
CROSS JOIN operatori 1 jadvaldagi xar bir element uchun 2 jadvaldagi elementlarni bog‘lab chiqadi.
SQL CROSS JOIN operatorining sintaksisi quyidagi ko‘rinishda bo‘ladi:
|
SELECT column_names [,... n] FROM
Table_1 CROSS JOIN Table_2
|
SQLFULL OUTER JOIN operatori 1 jadvaldagi xar bir element uchun 2 jadvaldagi elementlarni bog`lab chiqadi.
SQL FULL OUTER JOIN operatorining sintaksisi quyidagi ko‘rinishda bo‘ladi:
-
|
So‘rov : SELECT column_names [,... n]
Table_1 FULL JOIN Table_2
ON condition
|
8.4 – rasm. Full outer join operatorining Venn diagrammasi orqali ko’rinishi
Ishni bajarish tartibi
SQL INNER JOIN operatori
So‘rov: SELECT *FROM zavod_xodimlari
INNER JOIN kon_xodimlari
ON zavod_xodimlari.FISH=kon_xodimlari.FISH;
Natija:
8.5 - rasm. Inner join qo’llanishi natijasi
2. LEFT JOIN operatori
So‘rov: SELECT * FROM zavod_xodimlari
LEFT JOIN kon_xodimlari
ON zavod_xodimlari.manzili = kon_xodimlari.manzili;
|
| |
