By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.
Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you do not need to even use the CASE WHEN Statement at all and you could simply replace it with Boolean logic. Now Boolean logic isn't a predefined topic per se, just an implementation. Take for example this CASE WHEN Statement:
SELECT *
FROM Pricelist_March
WHERE price CASE PriceID
WHEN 0 THEN 300
WHEN 1 THEN 400
END
This can be replaced by the following:
SELECT *
FROM Pricelist_March
WHERE
PriceID = 0 AND price PriceID = 1 AND price
