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  临冰听雪丶  阅读(170)  评论(0)    收藏  举报