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

sqlserver分页语句

标签：over   row   nbsp   table   sqlserver   ble   ber   分页   tab