表A有n(n>10000)条记录,现在想每次从A表中取出10条记录(不足10的全部取出)

select A.a,A.b,A.c
 from (select row_number() over(order by c) num,a,b,c
         from 表A）A
where num > startnum
  and num <= endnum