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%



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to