컴퓨터활용능력 1급 필기 · 2018년 2회 · 58번

Question

다음 중 아래와 같은 결과를 표시하는 SQL문은?

Accepted Answer

SELECT * FROM book ORDER BY [출간연도] ASC, [저자] ASC;

Answer

SELECT * FROM book ORDER BY [저자], [출간연도];

Answer

SELECT * FROM book ORDER BY [출간연도] DESC, [출판사] DESC;

Answer

SELECT * FROM book ORDER BY [저자] DESC, [출간 연도] ASC;