rem rem $Header: summit2.sql 27-jun-2000.12:30:22 slari Exp $ rem rem Copyright (c) 1991, 2000 Oracle Corporation. All rights reserved. rem rem NAME rem summit2.sql - rem DEscr iptION rem rem RETURNS rem rem FUNCTION rem Create and populate tables
1:找出公司里收入最高的前三名员工: SQL> select rownum, last_name, salary 2 from (select last_name, salary 3 from s_emp 4 order by salary desc) 5 where rownum select rownum, last_name, salary 2 from s_emp 3 where rownum<=3 4 or der by salary desc; ROWNUM LAST_