mysql 常见sql总结

#删除多条重复记录，只保留一条
DELETE
FROM
ill_judge_report
WHERE
id NOT IN (
SELECT
id
FROM
( SELECT min( id ) AS id, count( 1 ) count FROM ill_judge_report WHERE RULE_NAME = 'AI识别车厢内装载罐体车' GROUP BY PLATE_NUMBER ) a
WHERE
count > 1
)
AND RULE_NAME = 'AI识别车厢内装载罐体车'