将GROUP BY添加到要检查重复的字段 您的查询可能看起来像

SELECT field1, field2, field3, ......   FROM table GROUP BY field1

将检查Field1以排除重复记录

或者你可能会问

SELECT *  FROM table GROUP BY field1

字段1的重复记录被排除在SELECT中

这是一个简单的解决方法:

 WITH cte AS /* Declaring a new table named 'cte' to be a clone of your table */
 (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY val1 DESC) AS rn
 FROM MyTable /* Selecting only unique values based on the "id" field */
 )
 SELECT * /* Here you can specify several columns to retrieve */
 FROM cte
 WHERE rn = 1

select min(table.id), table.column1
from table 
group by table.column1

SELECT *
FROM tblname
GROUP BY duplicate_values
ORDER BY ex.VISITED_ON DESC
LIMIT 0 , 30

在ORDER BY我刚刚把例子放在这里，你也可以在这里添加ID字段

SELECT  c2.field1 ,
        field2
FROM    (SELECT DISTINCT
                field1
         FROM   dbo.TABLE AS C
        ) AS c1
        JOIN dbo.TABLE AS c2 ON c1.field1 = c2.field1

SELECT * from table where field in (SELECT distinct field from table)