Re: percentages of a column - Mailing list pgsql-sql

"Andreas" <maps.on@gmx.net> writes:

> Example:
>
> Fruit          Count       %
> --------------------------
> Bananas       5          10%
> Apples       15          30%
> Oranges     30          60%

select fruit_name, count(*),       round(count(*)::numeric / (select count(*) from basket) * 100, 0)::text||'%' as "%"
frombasket group by fruit_nameorder by "%";
 
fruit_name | count |  %  
------------+-------+-----Bananas    |     5 | 10%Apples     |    15 | 30%Oranges    |    30 | 60%
(3 rows)

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com