SQL AND operatori
SQL AND operatori
WHERE bandi bir yoki bir nechta AND operatorlarini o‘z ichiga olishi mumkin.
AND operatori bir nechta shartlar asosida yozuvlarni filtrlash uchun ishlatiladi.
Eslatma: AND operatori barcha shartlar TRUE bo‘lsa, yozuvni ko‘rsatadi.
Quyidagi SQL kodi Ispaniyadan nomi 'G' harfi bilan boshlanadigan barcha mijozlarni tanlaydi:
Misol
Select all customers where Country is "Spain" AND CustomerName starts with the letter 'G':
SELECT *
FROM Customers
WHERE Country = 'Spain' AND CustomerName LIKE 'G%';
O‘zingiz sinab ko‘ring »
AND sintaksisi
SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND 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 |
Barcha shartlar rost bo‘lishi kerak
Quyidagi SQL kodi mamlakati Brazil, shahri Rio de Janeiro va CustomerID qiymati 50 dan katta bo‘lgan barcha mijozlarni tanlaydi:
Misol
SELECT * FROM Customers
WHERE Country = 'Brazil'
AND City = 'Rio de
Janeiro'
AND CustomerID > 50;
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 »
Video: SQL AND operatori
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!