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

Home -> Community -> Usenet -> c.d.o.misc -> Re: group by problem!!!

Re: group by problem!!!

From: Anurag Varma <avdbi_at_hotmail.com>
Date: 17 Aug 2001 09:29:46 -0700
Message-ID: <7171ca2d.0108170829.35ed96e1@posting.google.com> 





Better still ... do:



SELECT sector,SUM(DECODE(status,'C',1,0)) closed_events,COUNT(*) all_events
FROM table


GROUP BY sector;
Received on Fri Aug 17 2001 - 11:29:46 CDT












Original text of this message













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