--第一种方式[针对数据量较小的分页统计]
drop table #tmp;
Select identity(int,1,1) as id,* into #tmp from songlist
select sourcefilename ,songname,videotype,singerid,singer,songpic from #tmp where id between 200 and 300;
select count(*) as n1,ceiling(count(*)/200) as n2 from songlist;
--第二种方式[主要针对数据量稍微大点的 分页统计 先按照主键排序]
declare @pagerow int ,@pageid int
set @pagerow = 100;--每页显示的个数
set @pageid = 2;--第几页
select top @pagerow sourcefilename, songname,videotype,singerid,singer,songpic from songlist
where sourcefilename not in (select top @pagerow*(@pageid-1) sourcefilename from songlist order by sourcefilename)
order by sourcefilename;
追问能举个例子吗?看不懂上面的代码啊?
追答就是给ec_order 表添加一个字段 让他自动增长 然后插入到临时表中 然后直接用between and 查询 要查的 区间就可以了