percentage issue.

[Aria]

Hi folks,
I have a table with a country column. I want to do one query that will give me the percentage of each country in my table.
select
country,
((count(rowid)/total_rows)*100)
from my_table
group by country
i.e.
UK 20
USA 43
SWE 37
Thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try like this:
SELECT country, count(1)/(SELECT COUNT(*) FROM countries)*100.0 AS pct
FROM countries GROUP BY country -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --