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

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

SQL表结构如下图：

SQL 分页语句：

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