sql server中分页sql写法

TOTAL_COUNT：总条数

PAGE_SIZE：每页10000条数据

PAGE_COUNT：总页数

START_ROW：开始行

START_PAGE：开始页

select 'xxx' name,
       count(1) TOTAL_COUNT,
       10000 PAGE_SIZE,
       cast(round(CEILING(count(1)*1.0/10000),0) as int)  PAGE_COUNT,
       0 START_ROW,
       0 START_PAGE
from table1
where data >='2020-01-01 00:00:00' ;