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)
mysql 进行过滤查询
最新推荐文章于 2024-04-28 16:10:04 发布