SQL Server 怎么去重查询

SQL Server 怎么去重查询 条件是根据表中某一个字段去掉重复的保留一条有效数据 获取表中所有有效数据

select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)

使用distinct去重