SQL OR operatori
SQL OR operatori
WHERE bandi bir yoki bir nechta OR operatorlarini o‘z ichiga olishi mumkin.
OR operatori bir nechta shartlar asosida yozuvlarni filtrlash uchun ishlatiladi.
Eslatma: OR operatori shartlardan birortasi TRUE bo‘lsa, yozuvni ko‘rsatadi.
Quyidagi SQL kodi Germany yoki Spain davlatlaridagi barcha mijozlarni tanlaydi:
Misol
Country qiymati Germany yoki Spain bo‘lgan barcha mijozlarni tanlash:
SELECT *
FROM Customers
WHERE Country = 'Germany' OR Country = 'Spain';
O‘zingiz sinab ko‘ring »
OR sintaksisi
SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR condition3 ...;
Demo ma’lumotlar bazasi
Quyida misollarda foydalanilgan Customers jadvalidan tanlanma keltirilgan:
| CustomerID | CustomerName | ContactName | Address | City | PostalCode | Country |
|---|---|---|---|---|---|---|
| 1 |
Alfreds Futterkiste | Maria Anders | Obere Str. 57 | Berlin | 12209 | Germany |
| 2 | Ana Trujillo Emparedados y helados | Ana Trujillo | Avda. de la Constitución 2222 | México D.F. | 05021 | Mexico |
| 3 | Antonio Moreno Taquería | Antonio Moreno | Mataderos 2312 | México D.F. | 05023 | Mexico |
| 4 |
Around the Horn | Thomas Hardy | 120 Hanover Sq. | London | WA1 1DP | UK |
| 5 | Berglunds snabbköp | Christina Berglund | Berguvsvägen 8 | Luleå | S-958 22 | Sweden |
Kamida bitta shart rost bo‘lishi kerak
Quyidagi SQL kodi City qiymati Berlin bo‘lgan, yoki CustomerName 'G' bilan boshlanadigan, yoki Country qiymati Norway bo‘lgan mijozlarni tanlaydi:
Misol
SELECT * FROM Customers
WHERE City = 'Berlin'
OR CustomerName LIKE 'G%'
OR Country = 'Norway';
O‘zingiz sinab ko‘ring »
AND va OR farqi
Agar barcha shartlar TRUE bo‘lsa, AND operatori yozuvni ko‘rsatadi.
OR operatori shartlardan birortasi TRUE bo‘lsa, yozuvni ko‘rsatadi.
AND va OR ni birlashtirish
AND va OR operatorlarini ham birlashtirishingiz mumkin.
Quyidagi SQL kodi Spain davlatidan nomi 'G' yoki 'R' bilan boshlanadigan barcha mijozlarni tanlaydi (to‘g‘ri natija olish uchun qavslardan foydalanishni unutmang):
Misol
SELECT ALL "G" yoki "R" bilan boshlanadigan ispancha Customers:
SELECT * FROM Customers
WHERE Country = 'Spain'
AND (CustomerName LIKE 'G%' OR CustomerName LIKE 'R%');
O‘zingiz sinab ko‘ring »
Qavslarsiz yuqoridagi SQL barcha mijozlar Ispaniyadan "G" bilan boshlanadi, shuningdek Country qiymatidan qat’iy nazar "R" bilan boshlanadigan barcha mijozlarni qaytaradi:
Misol
SELECT * FROM Customers
WHERE Country = 'Spain'
AND CustomerName LIKE 'G%' OR CustomerName LIKE 'R%';
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!