sql查询某条记录

select * from (SELECT t.*,ROWNUM AS RN FROM AWARDISSUE_FOOTBALL t ORDER BY ID DESC) WHERE RN=2

  

posted @ 2015-01-14 19:17  临冰听雪丶  阅读(162)  评论(0编辑  收藏  举报