SQL'da BETWEEN operatori nima?

SQL'da BETWEEN operatori, WHERE iborasida berilgan diapazondagi qiymatlarni tanlash uchun ishlatiladi. Diapazon boshlang'ich va oxirgi qiymatlarni o'z ichiga oladi.

Sintaksis:

SELECT column_list
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

• column_list: Tanlanadigan ustunlar.
• table_name: Ma'lumotlar olinadigan jadval.
• column_name: BETWEEN operatori qo'llaniladigan ustun.
• value1: Diapazonning boshlang'ich qiymati.
• value2: Diapazonning oxirgi qiymati.

Misol: 18 dan 65 yoshgacha bo'lgan mijozlarni tanlang, shu jumladan.

SELECT *
FROM Customers
WHERE Age BETWEEN 18 AND 65;

BETWEEN >= va <= operatorlari bilan tengdir. >= va <= bilan misol:

SELECT *
FROM Customers
WHERE Age >= 18 AND Age <= 65;

BETWEEN operatori matn va datetime qiymatlari bilan ham ishlatilishi mumkin.

Matn qiymatlari bilan misol: Nomi 'A' dan 'C' gacha bo'lgan mahsulotlarni tanlang.

SELECT *
FROM Products
WHERE ProductName BETWEEN 'A' AND 'Cez'; -- 'Cez' barcha nomlarni o'z ichiga oladi, 'C' bilan boshlanadiganlar

Datetime qiymatlari bilan misol: Ma'lum bir vaqt oralig'ida amalga oshirilgan buyurtmalarni tanlang.

SELECT *
FROM Orders
WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31';

Diapazondan qiymatlarni chiqarib tashlash uchun NOT BETWEEN operatori ishlatiladi.

Sintaksis:

SELECT column_list
FROM table_name
WHERE column_name NOT BETWEEN value1 AND value2;

NOT BETWEEN bilan misol: 18 dan 65 yoshgacha bo'lmagan mijozlarni tanlang.

SELECT *
FROM Customers
WHERE Age NOT BETWEEN 18 AND 65;