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
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:
PROTECTED]
Subject: SQL Query Problem(possilble duplicate send, Sorry!)
Date: Tue, 13 Jan 2004 12:34:35 -0800
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