정오표

손에 잡히는 10분 SQL 정오표입니다.

 

69쪽
SELECT prod_id, quantity, item_price
FROM OrderItems
ORDER BY order_num = 20008;

—->where order_num = 20008;

—————————————————
80쪽
SELECT order_num
FROM Orders
WHERE to_number(char(order_Date, ‘YYYY’)) = 2012;

—->
WHERE to_number(to_char(order_Date, ‘YYYY’)) = 2012;