MYSQL,HAVING()的使用,确定分组后字段是否超过1
SELECT table1, table2, count(1)
FROM table_name
GROUP BY table1, table2
HAVING count(1) > 1
MYSQL,HAVING()的使用,确定分组后字段是否超过1
SELECT table1, table2, count(1)
FROM table_name
GROUP BY table1, table2
HAVING count(1) > 1