with tabs as
(
select ROW_NUMBER() over(partition by TASKUSER order by INCIDENT) as rows,* from UltimusDB.dbo.TASKS where INCIDENT=888
)
select MAX(rows) as '总计',TASKUSER from tabs group by TASKUSER
转载于:https://www.cnblogs.com/yangpeng-jingjing/p/5824964.html