I
DB2 9 Family Fundamentals
300 Questions
Question No. 1
Given the following query:
SELECT quantity,
CASE WHEN itemcode = '099' THEN 'SILVER'
WHEN itemcode = '788' THEN 'GOLD'
WHEN itemcode = '899' THEN 'PLATINUM'
ELSE 'ERROR'
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE expression?
SUPPLIER
------------------------------------------
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
Choose the correct option from the given list.
01 / 300