oracle
select * from (select * from nncredit_article where classoid='22' order by nncredit_article.RECORD_CREATE_TIME DESC ) s where rownum<='1' and verifystate=0 order by rownum
------解决思路----------------------
SELECT * FROM (SELECT *,rownum=ROW_NUMBER()OVER(ORDER BY RECORD_CREATE_TIME DESC) FROM nncredit_article) AS s WHERE s.rownum<=1 AND verifystate=0
第1条记录的verifystate!=0时，没有记录的
------解决思路----------------------
复制少了where
SELECT * FROM (SELECT *,rownum=ROW_NUMBER()OVER(ORDER BY RECORD_CREATE_TIME DESC) FROM nncredit_article where classoid='22') AS s WHERE s.rownum<=1 AND verifystate=0