percentages of a column - Mailing list pgsql-sql

From Andreas
Subject percentages of a column
Date
Msg-id 4685BC84.2090106@gmx.net
Whole thread Raw
Responses Re: percentages of a column  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-sql
Hi,

There is a Select that calculates some SUMs of objects.
I'd like to show a list of counts and percentages of this counts based 
on the sum of all counts.
Is that possible in a SELECT statement?

Example:  

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




pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Next
From: Gregory Stark
Date:
Subject: Re: percentages of a column