Essential Books

Using CASE in UPDATE

suggest change

sample on price increases: 

UPDATE ItemPrice
SET Price = Price *
  CASE ItemId
    WHEN 1 THEN 1.05
    WHEN 2 THEN 1.10
    WHEN 3 THEN 1.15
    ELSE 1.00
  END
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

CASE:
*CASE
*Use CASE to COUNT the number of rows in a column match a condition.
*Searched CASE in SELECT Matches a boolean expression
*CASE in a clause ORDER BY
*Shorthand CASE in SELECT
*Using CASE in UPDATE
*CASE use for NULL values ordered last
*CASE in ORDER BY clause to sort records by lowest value of 2 columns
Table Of Contents