SQL CASE Expression
- CASE. WHEN condition1 THEN result1. WHEN condition2 THEN result2. WHEN conditionN THEN resultN. ELSE result.
- ExampleGet your own SQL Server. SELECT OrderID, Quantity, CASE. WHEN Quantity > 30 THEN ‘The quantity is greater than 30’
- Example. SELECT CustomerName, City, Country. FROM Customers. ORDER BY.
Shathana. S.R. Answered question July 5, 2023