Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL Statement problem

SQL Statement problem

From: miike <mspiller_at_tscnet.com>
Date: 2000/05/10
Message-ID: <3919622B.AFF39C2D@tscnet.com>#1/1 






I have a table (workload) that has a column (category_type) that has 5
different possible entries(training, technical, clerical, operations,
supply). Is there a way to write a SQL statement to get a listing by
percentage of each entry type (i.e. training =25%, technical=30%, etc)
so that I can create a piechart to give my supervisor?
TIA.



-mike-
Received on Wed May 10 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US