CASE
CASE
CASE buyrug‘i to uchun ishlatiladi
sharoitlar asosida turli xil mahsulot yaratish.
Quyidagi SQL bir nechta shartlardan o‘tadi va belgilangan shart bajarilganda qiymatni qaytaradi:
Misol
SELECT OrderID, Quantity,
CASE
WHEN Quantity > 30
THEN 'The quantity is greater than 30'
WHEN Quantity =
30 THEN 'The quantity is 30'
ELSE 'The quantity is under 30'
END
FROM OrderDetails;
O‘zingiz sinab ko‘ring »
Quyidagi SQL mijozlarga shahar bo‘yicha tartib beradi. Biroq, agar City NULL bo‘lsa, mamlakat bo‘yicha tartib bering:
Misol
SELECT CustomerName, City, Country
FROM Customers
ORDER BY
(CASE
WHEN City IS NULL THEN Country
ELSE City
END);
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!