Top-N 사용법
작성자 관리자 작성시간 2003-06-25 15:19:26
 

select rownum as RANK, last_name,salary
from (select last_name,salary from employees
order by salary desc)
where rownum <= 3 ;


목록 | 입력 | 수정 | 답변 | 삭제