短实训-数据库基础（三）

1.TOP-N查询

SELECT [列名],ROWNUM
FROM (SELECT [列名])
FROM 表名
ORDERBY TOP-N操作的列 ASC|DESC)
WHERE ROWNUM <=5

1.查询工资最少的前五名员工姓名，工资

SELECT ENAME,SAL,ROWNUM
FROM (SELECT ENAME,SAL
FROM EMP
ORDER BY SAL)
WHERE ROWNUM <= 5

就只有这些ORZ~~
2017.9.8