mysql查询某条数据出现两次以上
查询order_id重复出现两次以上
select order_id from t_test where 1=1 GROUP BY order_id HAVING count(order_id ) > 1;
查询order_id,phone重复出现两次以上
select * from t_test where 1=1 GROUP BY order_id,phone HAVING count(order_id+phone ) > 1;
select order_id from t_test where 1=1 GROUP BY order_id HAVING count(order_id ) > 1;
select * from t_test where 1=1 GROUP BY order_id,phone HAVING count(order_id+phone ) > 1;