MSSQL查询重复数据

select M_Account from tb_Logistic where L_Check=0 group by M_Account having count(*) > 1

Select * From 表 Where 重复字段 In (Select 重复字段 From 表 Group By 重复字段 Having Count(*)>1)