SQL去掉某个字段重复记录

SELECT * 
FROM dbo.table1 
WHERE Row_ID IN (SELECT MAX(Row_ID) FROM table1 GROUP BY col1)