SELECT * FROM dbo.table1 WHERE Row_ID IN (SELECT MAX(Row_ID) FROM table1 GROUP BY col1) 转载于:https://www.cnblogs.com/Kelly-Zheng/p/5207024.html