SQL 单表多条记要分组查询分页代码_SQL

SQL 单表多条记录分组查询分页代码

SQL表结构如下图：

SQL 分页语句：

[sql]?view plaincopy

<span?style="font-size:16px;">SELECT?TOP?5?*,(select?count(*)???inum?from???
(select?distinct??AreaID,AreaTypeID,lifeYear,[State],RelatedID?from?MonitorBaseEnterInfo?where??1=1)?i?)?as?CountNum??FROM???????
??(SELECT?ROW_NUMBER()?OVER?(?order?by?lifeYear?desc)?AS?RowNumber,*?FROM?(select?distinct??AreaID,AreaTypeID,lifeYear,[State],RelatedID???
????from?MonitorBaseEnterInfo?where??1=1?)?mm??)?A??
?????WHERE?RowNumber?>?5?*(1-1)</span>??

查询第一页和第二页如下图：