sql distinct 去重复数据问题
来源:百度知道 编辑:UC知道 时间:2024/07/01 03:41:31
问个问题。比如有三行数据
id name
1 hh
2 hh
3 hh
我只想取名字相同最小的那个号码,结果集就是
1 hh
那sql咋写。。
id name
1 hh
2 hh
3 hh
我只想取名字相同最小的那个号码,结果集就是
1 hh
那sql咋写。。
select * from table a (select min(id) id,name from table_name group by name) b
where a.id=b.id
select min(id) from tablename where name in (select name,count(name) from tablename group by name having count(name)>1)
来个最简单的:
select name,min(id) from table group by name
select * from table a (select min(id) id,name from table_name group by name) b where a.id=b.id
select distinct(name) name,min(id) id
from [表名]
group by name
结果是 hh 1
因为distinct约束的项必须放在第一列.
select name, min(id) as id
from table
group by name