统计每一个客户最近下的订单是第几次下的订单

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