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);