November 19th, 2008
CASE (IF-THEN-ELSE), Part 3 of 3
Posted by
admin in
G. ANSI Scalar Functions
Search CASE allows you to use alternate comparison ranges to determine the results.
SELECT STORE_NAME,
CASE
WHEN YTD_QUOTA IS NULL
THEN 'Unknown'
WHEN YTD_QUOTA < 100000
THEN 'less than 100,000'
WHEN YTD_QUOTA < 5000000
THEN 'between 100,000 and 5,000,000'
ELSE 'over 5,000,000'
END
AS 'Store Quota'
FROM STORE_TBL
ORDER BY YTD_QUOTA;
Result:
          
