sql 求总行数和分页语句结合

SELECT * FROM EA_Record 

 

 SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY Id) AS RowNumber, COUNT(*)  OVER()  as count , * FROM EA_Record WHERE 1=1) as A

WHERE RowNumber between 1 and 100