Head First SQL 6장
posted on 29 Jun 2017 under category SQL
UPDATE my_table
SET new_column =
CASE
WHEN column1 = value1 THEN newValue1
WHEN column2 = value2 AND columnB = valueB THEN newValue2
ELSE newValue3
END;
SELECT title, category
FROM movie_table
WHERE category = ‘family’
ORDER BY title;
SELECT title, category
FROM movie_table
LIMIT 5