Re: Query to get Percentages

In article <1994Jun28.174755.8671_at_ctp.com>, abhat_at_ctp.com (Anju Bhatnagar) says:
>I need to write a query that will generate a report of the type:
>
>Vendor Problem Total Number Percentage of Complaints that
> of Complaints need a followup (followup = 'Y')
>------ ------- ------------- ---------------------------------

to select a percentage, you must first know the total number of rows. do this first:

column count new_val kount
select count(*) count from complaints;

this creates a "def" variable which contains the count; now you are ready to calculate percentages:

select vendor,problem,count(*),100*count(*)/&kount from complaints group by vendor,problem;

--
Dave Mausner, Senior Consultant, Braun Technology Group, Chicago.