[SQL]중복 값 갯수 구하기

SELECT count( account ) AS accounts, account
FROM cb
GROUP BY account
ORDER BY accounts DESC
LIMIT 0 , 30