Question

用sql语句查询结果并排除重复的数据

SQL语句

Answer 1

3楼正解， 1 2 楼的不要误导人家行不，distinct只对单个列的去重有用，

Answer 2

select distinct * from xbiao group by xy

Answer 3

SELECT DISTINCT * FROM xxx

Answer 4

select distinct 列名 from 表名