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