Home -> Usenet -> comp.databases.oracle -> Query to get Percentages

Query to get Percentages

From: Anju Bhatnagar <abhat_at_ctp.com>
Date: Tue, 28 Jun 1994 17:47:55 GMT
Message-ID: <1994Jun28.174755.8671_at_ctp.com> 






Hi everyone,



Consider a table 'Complaint' with the following columns:



Complaint




complaintID   NUMBER(6) /* Primary Key */
complaintDate DATE

vendor        VARCHAR2(10)
problem       VARCHAR2(10)
followup      CHAR(1) /* This is a flag to indicate if the
                    complaint needs a follow up 'Y' or 'N' */
		 




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') 
------   -------   -------------   ---------------------------------





The output should break on Vendor and Problem. 



Any help would be appreciated.



Thankyou







-- 
 /\/\ |Anju Bhatnagar                     | 
/ /_.\|Cambridge Technology Partners, Inc.| 
\  /./|304 Vassar St.  Cambridge, MA 02139| 
 \/\/ |Voice:617-374-8518 Fax:617-374-8300| 


Received on Tue Jun 28 1994 - 19:47:55 CEST












Original text of this message