SQL 单表多条记录分组查询分页代码
SQL表结构如下图：
SQL 分页语句：
- <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>
查询第一页和第二页如下图：