摘要： 查找全部重复记录Select * From 表/视图 Where 重复字段 In (Select 重复字段 From 表/视图 Group By 重复字段 Having Count(*)>1)如:select * from case_app_viewwhere case_id in (selectcase_id fromcase_app_view group by case_id havin... 阅读全文