MYSQL 常用语句

2021-07-20 本文已影响0人 webjiacheng

//查重
SELECT COUNT(*) AS repetitions,id,sub_order_no FROM order GROUP BY sub_order_no HAVING repetitions > 1;