sqlserver分组后取日期最新的一条 SELECT m1.* FROM 表 m1 INNER JOIN ( SELECT MAX(CreateDate) AS CreateDate , 分组字段mark FROM 表 GROUP BY 分组字段mark ) m2 ON m2.CreateDate = m1.CreateDate AND m2.mark = m1.mark