Question

다음의 실행 결과를 조회하는 SQL문은? [그림]

Accepted Answer

SELECT RANK() OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) RN, DEPTNO, SAL FROM LIMBEST.EMP;

Answer

SELECT NTITLE() OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) RN, DEPTNO, SAL FROM LIMBEST.EMP;

Answer

SELECT DENSE_RANK() OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) RN, DEPTNO, SAL FROM LIMBEST.EMP;

Answer

SELECT ROW_NUM() OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) RN, DEPTNO, SAL FROM LIMBEST.EMP;

SQLD(SQL 개발자) 기출 · 윈도우 함수

이 문제 풀어보기