mysql 数据表中查找重复记录
示例，查询出订单号相同的数据
select order_id,count(*) as count from hz_order_enquiry group by order_id having count>1;
结果图
MySQL数据表中查找重复记录
分享到：
示例，查询出订单号相同的数据
select order_id,count(*) as count from hz_order_enquiry group by order_id having count>1;
结果图
