ROW_NUMBER() OVER() PARTITION BY
sql中用 ROW_NUMBER() OVER() PARTITION BY 实现分组排序,具体如下:
https://www.cnblogs.com/willingtolove/p/10623841.html
在C#中,用linq代码实现sql中分组排序的方法,具体如下:
https://stackoverflow.com/questions/9980568/row-number-over-partition-by-xxx-in-linq