摘要: 1 using System; 2 using System.Collections.Generic; 3 using System.Diagnostics; 4 using System.IO; 5 using System.Reflection; 6 using System.Threading 阅读全文
posted @ 2022-08-29 12:52 Mr_Xul 阅读(119) 评论(0) 推荐(0) 编辑
摘要: 1 SELECT 2 [字段1], 3 [字段2], 4 [字段n] 5 FROM 6 ( SELECT *, ROW_NUMBER ( ) OVER ( PARTITION BY [分组字段1], [分组字段2] ORDER BY [排序字段1] DESC ) AS rn FROM [表名] ) 阅读全文
posted @ 2022-08-29 09:59 Mr_Xul 阅读(17) 评论(0) 推荐(0) 编辑