Question

数据库查询去掉某字段重复项

如有表 ,我想查询时去掉name的重复项，以id倒序排序，理想查询结果为





Answer 1

select *, count(distinct name) as ccc from table group by name order by id desc;
查询结果中最终会多出来一个字段ccc，不用这个ccc字段就可以了
使用其他的办法，要么是效率不高，要么是返回不了你想要的结果集。

Answer 2

可以这样写
select id,name,msg from table1 where id = (select max(id) from table1 b where table1.name = b.name)
或
select id,name,msg from table1 where not exists(select * from table1 b where table1.name = b.name and table1.id < b.id)
如果要排序的话可以再在后面加order by id desc

Answer 3

SELECT a.* FROM dd a RIGHT JOIN dd b ON a.name=b.name AND a.id != b.id GROUP BY a.`name`

Answer 4

SELECT * FROM 表 WHERE id IN (select MAX(id) from 表 GROUP BY name);

Answer 5

distinct(字段名)