获取最常用行值的％

Question

I track visitors country in my website and using this mysql query to get top visitor country names.

mysql_query("SELECT id,country, count(*) as num FROM track GROUP BY country ORDER BY count(*) desc limit 5")

It works perfectly. However, I want to get %s of the countries. How can I do that ?

Answer 1

This join will report percentages:

select id, country, num, num*100/total pct
from (SELECT id,country, count(*) as num
      FROM track GROUP BY country
      ORDER BY num desc limit 5) x
join (select count(*) total from track) y