sqlserver分页语句
select * from (
select row_number() over(order by id) as rowid,* from table where 1=1
) tt
select count(1) as countRow from (
select * from table where 1=1
) tt
whereStr = String.Format(@" and t.rowid BETWEEN {0} AND {1}", start, end);
}
sql =
String.Format(@"SELECT [EntName]
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY a.CreateTime desc ) rowid ,
a.[EntName]
FROM dbo.BT_NeedFreshEnt a where Status=1
) t
WHERE 1=1 {0} ;
select count(1) c from BT_NeedFreshEnt
",whereStr);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步