SQL Server 排序分组row_number()
select refdate,
left(convert(varchar,refdate,112),6),
transid,
ROW_NUMBER() over(partition by left(convert(varchar,refdate,112),6) order by RefDate ,TransId ) as rows
from OJDT
select refdate,
left(convert(varchar,refdate,112),6),
transid,
ROW_NUMBER() over(partition by left(convert(varchar,refdate,112),6) order by RefDate ,TransId ) as rows
from OJDT