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
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