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 ;


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦