Oracle拾遗(1)--实现SELECT TOP N的方法

ORACLE不支持SELECT TOP语句，所以在ORACLE中经常是用ORDER BY跟ROWNUM的组合来实现SELECT TOP N的查询:

 

SELECT ROWNUM as "行号", a.* FROM D_AREA a
WHERE ROWNUM < 10
ORDER BY ROWNUM DESC--ASC