您需要为此使用GROUP BY
子句:
SELECT val1, val2, val3, count(*) AS count
FROM mytable GROUP BY val1, val2, val3
在MySQL中的多个列上不同
您需要为此使用GROUP BY
子句:
SELECT val1, val2, val3, count(*) AS count
FROM mytable GROUP BY val1, val2, val3