Re: [SQL] percentages of a column

"Andreas" <[EMAIL PROTECTED]> writes: > Example: > > Fruit Count % > -- > Bananas 5 10% > Apples 15 30% > Oranges 30 60% select fruit_name, count(*), round(count(*)::numeric / (select count(*) from basket) *

[SQL] percentages of a column

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%