oracle 查询第二条记录

 

方法一：查询结果相减

select * from (select * from ss ORDER BY CANTIME desc )
where rownum<=2
minus
select * from (select * from ss ORDER BY CANTIME desc )
where rownum<=1

 

方法二：用rownum来查询区分记录

select *
          from (select t.*, rownum as rn
            from B_XXX_PDF t
           where writid = '1254565545555'
                      and pdfzt = '0'
           order by createtime desc)
         where rn = 2

 

方法三：子查询实现

select reemployeeid, scantime

from(select t.reemployeeid,

t.scantime,

RANK() OVER(orderby scantime) asRowNumber

fromtab t) b

whereb.RowNumber + 1 = (selectmax(RowNumber)

from(select t.reemployeeid,

t.scantime,

RANK() OVER(orderby scantime) asRowNumber

fromtab t))