贴一个 能执行 通过的 ... 通不过 不采纳
select * from (select t.* , rownumber() over( order by c) as rowno from table t ) temp where temp.rowno between 1 and 10