select distinct tel, name
from ztest
where name in (select min(name) from ztest group by tel)
如何查询数据库中重复记录的一条记录
最新推荐文章于 2024-04-17 15:25:46 发布
select distinct tel, name
from ztest
where name in (select min(name) from ztest group by tel)