一个分页查询语句，全当笔记，以后会用到

SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.id )AS Row, T.* from table  T WHERE 1=1 ) TT WHERE TT.Row between 1 and 20;
select count(1) from table where 1=1