ORACLE查询分页过程中排序不准确，需要先排序后分页

ORACLE查询分页过程中排序不准确
## 正常查询
但是在查询分页过程中排序不准确
例如：查出来的是2016年的数据

SELECT
	* 
FROM
TECH_BD
WHERE 
ID NOT IN (SELECT id FROM TECH_BD WHERE  rownum < 0)
AND rownum < 10 
 ORDER BY PUB_TIME DESC

找网上的帖子需要事先排序

SELECT
	 *
FROM
(SELECT * FROM TECH_BD ORDER BY PUB_TIME DESC)
WHERE 
ID NOT IN (SELECT id FROM TECH_BD WHERE  rownum < 0)
AND rownum < 10 

**

总结：先排序后分页

**