SQL分组并排序
2020-04-30 本文已影响0人
ShrJanLan
result.png
SELECT ROW_NUMBER() OVER(PARTITION BY [要分组的字段] ORDER BY [排序字段]) idNumber,* FROM [表名] WHERE [字段名]=[字段值]
SELECT ROW_NUMBER() OVER(PARTITION BY [要分组的字段] ORDER BY [排序字段]) idNumber,* FROM [表名] WHERE [字段名]=[字段值]
