select * from (
select row_number() over (order by CREATE_TIME desc) as row_number,id,name from table
) t where t.row_number > 0 fetch first 10 rows only
每页10条
select * from (
select row_number() over (order by CREATE_TIME desc) as row_number,id,name from table
) t where t.row_number > 0 fetch first 10 rows only
每页10条
转载于:https://my.oschina.net/xinyuanKong/blog/868466