2024-12-14 厉飞雨 阅读(7) 评论(0) 赞(0)

**查出重复的type** SELECT type FROM table GROUP BY type HAVING count(type) > 1; **查出重复的type数据中最小的id** SELECT min(id) FROM table GROUP BY type HAVING count(type) > 1; **查出重复的type...