select ROW_NUMBER() over(order by Id ASC) as 'NO',OpDate
from tb_Reporter
group by Id,OpDate
大概就是这个意思了
------解决思路----------------------
小調一下
select ROW_NUMBER() over(partition by OpDate order by Id ASC) as 'NO',OpDate
from tb_Reporter
------解决思路----------------------
select ROW_NUMBER() over(partiton by convert(varchar(10),OpDate,120) order by Id ASC) as 'NO',OpDate
from tb_Reporter
group by Id,OpDate