Mavzu: Union,Intersect va Minus standart so’zidan foydalanish. Amaliy masala nomi


Download 165 Kb.
bet2/3
Sana04.07.2020
Hajmi165 Kb.
#122890
1   2   3
Bog'liq
1-labaratoriya(MB)


1-rasm(tovar1 jadvali) 2-rasm(tovar2 jadvali)



Union operatori orqali so’rov yozamiz(3-rasm) va so’rovni tasdiqlab quyidagi natijani olamiz(4-rasm)

3-rasm(masala shartiga ko’ra so’rov) 4-rasm(natija)



Endi o’xshash kortejlarni topish uchun Intersect operatoridan foydalanib so’rov kiritamiz(5-rasm) va uning MYSQLdagi yechimiga ega bo’lamiz(6-rasm)

5-rasm (MYSQLdagi so’rov)



6-rasm natija


Download 165 Kb.

Do'stlaringiz bilan baham:
1   2   3




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling