查找全部重复记录
Select * From 表/视图 Where 重复字段 In (Select 重复字段 From 表/视图 Group By 重复字段 Having Count(*)>1)
如:
select * from case_app_view
where case_id in (select case_id from case_app_view group by case_id having count(case_id) > 1)
