select *
from
(
select row_number() over(order by 排序字段) id,*
from 表
) t1
where id=3
因为你啥也没写,,只能这样写了
select * from tablename where 行id=xxoo
select t.* from (select row_number() over(order by 字段名 )as RowNum,* from 表名 )t
where t.RowNum=3
后面加 limit 2,0;