Viktor wrote:
Hello all,
I am working with a query that does some counts. I've hit a brick wall
and can't get passed trying to figure out how I can make the query show
percentages %.
Here is the query:
select COUNTRY,
count (MSS) COUNT_MSS
FROM (
SELECT DISTINCT
Thanks for your reply! Will try it now. Will this work in 8i?
Viktor
Bricklen Anderson [EMAIL PROTECTED] wrote:
Viktor wrote: Hello all, I am working with a query that does some counts. I've hit a brick wall and can't get passed trying to figure out how I can make the query show percentages
Viktor wrote:
Thanks for your reply! Will try it now. Will this work in 8i?
Viktor
If it works at all, then it should work in both 8i and 9i, although I
don't have a version of 8i handy right now to try this on.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
hi,
There is a function RATIO_BY_PERCENT or something very similar to this in
SQL
just find it out
this gives u individual contributions as compared to the whole thing.
Regds,
Rohan
From: Viktor [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL