select * from Table
where Name in (select Name from Table where type=1 group by Name having count
(Name ) > 1 )
order by Name desc
sql 查询重复数据
最新推荐文章于 2024-01-19 14:37:34 发布
select * from Table
where Name in (select Name from Table where type=1 group by Name having count
(Name ) > 1 )
order by Name desc