MySQL - group by and count rows

SELECT COUNT(*) FROM

(select x,y from xx group by y) sub;

출처 : http://stackoverflow.com/questions/2631097/mysql-group-by-and-count-rows-problem