由于ORACLE不支持SELECT TOP语句,所以在ORACLE中经常是用ORDER BY跟ROWNUM的组合来实现SELECT TOP N的查询。
简单地说,实现方法如下所示:
SELECT * FROM
(SELECT ZHSW_GG.Caseno,ZHSW_GG.Title,ZHSW_GG.Draftdate FROM ZHSW_GG ORDER BY Draftdate desc)
WHERE ROWNUM <= 5
ORDER BY ROWNUM ASC
由于ORACLE不支持SELECT TOP语句,所以在ORACLE中经常是用ORDER BY跟ROWNUM的组合来实现SELECT TOP N的查询。
简单地说,实现方法如下所示:
SELECT * FROM
(SELECT ZHSW_GG.Caseno,ZHSW_GG.Title,ZHSW_GG.Draftdate FROM ZHSW_GG ORDER BY Draftdate desc)
WHERE ROWNUM <= 5
ORDER BY ROWNUM ASC