mysql 进行过滤查询

1.查找重复字段p_name的重复条数

Select p_name,count(*) as count from zyx_member group by p_name having count>1;

2.查询new 表中去除title字段的重复数据，显示id最大的那条数据

Select * From new Where id In (Select Max(id) From new Group By title) ；

3.查询表中重复数据

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