根据某个字段获取第n行的数据

不多说直接上
oracle写法
select * from(
select rownum as num,a.* from(
select * from table order by insert_dt desc
) a where rownum<n+1
) where num=n

sql写法
select * from(
select row_number() over(order by table.insert_dt desc) as num ,table.* from table
) a where a.num=n