select 分组序号=gid+1
,分组起始值=cast(gid*g+1 as varchar)+'-'+cast((gid+1)*g-1 as varchar)
,记录数
from(
select gid=id/g,记录数=count(*),g
from(
select id=id-1,g=((select max(id) from syscolumns)+29)/30
from syscolumns
)a
group by id/g,g
)a
select 分组序号=gid+1
,分组起始值=cast(gid*g+1 as varchar)+'-'+cast((gid+1)*g-1 as varchar)
,记录数
from(
select gid=id/g,记录数=count(*),g
from(
select id=id-1,g=((select max(id) from syscolumns)+29)/30
from 表
)a
group by id/g,g
)a