SQLD · 제54회 · 35번

Question

테이블에서 최신 데이터 5건만 추출하는 Top-N 쿼리를 ANSI 표준 SQL로 작성할 때 가장 올바른 구문은?

Accepted Answer

SELECT * FROM TAB ORDER BY DATE DESC FETCH FIRST 5 ROWS ONLY;

Answer

SELECT * FROM TAB FETCH FIRST 5 ROWS ONLY ORDER BY DATE DESC;

Answer

SELECT TOP 5 * FROM TAB ORDER BY DATE DESC;

Answer

SELECT * FROM TAB LIMIT 5 ORDER BY DATE DESC;