SQL BETWEEN operatori

BETWEEN operatori WHERE bandida belgilangan diapazondagi qiymatlarni tanlash uchun ishlatiladi.

Diapazon chegaralarni o‘z ichiga oladi - diapazonning boshlang‘ich va oxirgi qiymatlari ham natijaga kiritiladi.

Qiymatlar raqamlar, matn yoki sana bo‘lishi mumkin.

Misol

Narxi 10 va 20 oralig‘ida bo‘lgan barcha mahsulotlarni tanlash:

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

O‘zingiz sinab ko‘ring »

Sintaksis

SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;

Demo ma’lumotlar bazasi

Quyida misollarda foydalanilgan Products jadvalidan tanlanma keltirilgan:

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18.00
2	Chang	1	1	24 - 12 oz bottles	19.00
3	Aniseed Syrup	1	2	12 - 550 ml bottles	10.00
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	22.00
5	Chef Anton's Gumbo Mix	2	2	36 boxes	21.35

NOT BETWEEN

NOT BETWEEN operatori WHERE bandida belgilangan diapazondan tashqaridagi qiymatlarni tanlash uchun ishlatiladi.

Quyidagi SQL barcha mahsulotlar ni narxi 10 va 20 oralig‘ida bo‘lmagan 10 va 20 bilan qaytaradi:

Misol

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

O‘zingiz sinab ko‘ring »

BETWEEN va IN birgalikda

Quyidagi SQL barcha mahsulotlar ni narxi 10 va 20 oralig‘ida bo‘lgan 10 va 20 bilan qaytaradi. Shuningdek, CategoryID 1, 2 yoki 3 bo‘lishi kerak:

Misol

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20
AND CategoryID IN (1,2,3);

O‘zingiz sinab ko‘ring »

Matnli qiymatlar bilan BETWEEN

Quyidagi SQL barcha mahsulotlar ni ProductName alifbo tartibida BETWEEN "Geitost" va "Louisiana Hot Spiced Okra" bilan tanlaydi:

Misol

SELECT * FROM Products
WHERE ProductName BETWEEN 'Geitost' AND 'Louisiana Hot Spiced Okra'
ORDER BY ProductName;

O‘zingiz sinab ko‘ring »

Matnli qiymatlar bilan NOT BETWEEN

Quyidagi SQL barcha mahsulotlar ni ProductName EMAS BETWEEN "Geitost" va "Luiziana Hot Spiced Okra" bilan tanlaydi:

Misol

SELECT * FROM Products
WHERE ProductName NOT BETWEEN 'Geitost' AND 'Louisiana Hot Spiced Okra'
ORDER BY ProductName;

O‘zingiz sinab ko‘ring »

Sanalar bilan BETWEEN

BETWEEN operatori ma’lum bir sana yoki vaqt oralig‘idagi yozuvlarni filtrlash uchun foydalidir. Sana formati ma’lumotlar bazasiga mos kelishiga ishonch hosil qiling (masalan, “YYYY-AA-KK”).

Quyidagi SQL 1996 yil iyul oyida berilgan barcha buyurtmalarni tanlaydi:

Misol

SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';

O‘zingiz sinab ko‘ring »

Namuna jadvali

Quyida yuqoridagi misolda ishlatilgan Orders jadvalidan tanlanma keltirilgan:

OrderID	CustomerID	EmployeeID	OrderDate	ShipperID
10248	90	5	1996-07-04	3
10249	81	6	1996-07-05	1
10250	34	4	1996-07-08	2
10251	84	3	1996-07-08	1
10252	76	4	1996-07-09	2

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish