MySQL在多个列上计算不同的值

MySQL在多个列上计算不同的值

只需在

GROUP BY

子句中列出多列即可。

SELECt computer, user, count(*) AS countFROM loginGROUP BY computer, user