row_number() over()分组排序功能 partition by 用于给结果集分组-CSDN博客

网站介绍:select * from ( select row_number() over(partition by Gid order by Gid ASC) as RowN, * from( select b.Gid, a.OrderNo,b.Carcode from fit_CarOrder a inner join Fit_...