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: help needed with query

Re: help needed with query

From: Nis Jørgensen <nis_at_superlativ.dk>
Date: Wed, 13 Jun 2007 01:44:33 +0200
Message-ID: <466f2fea$0$90273$14726298@news.sunsite.dk> 





Nis Jørgensen skrev:



> Quick, dirty and untested

> 

> SELECT mgr_id,

> 	SUM(CASE WHEN acct_code LIKE 'A%' THEN inv_amt ELSE 0 END) AS act_code_A

> 	SUM(CASE WHEN acct_code LIKE 'B%' THEN inv_amt ELSE 0 END) AS  act_code_B

> GROUP BY mgr_id





Oops, forgot the FROM-clause:



FROM test_tbl



/Nis
Received on Tue Jun 12 2007 - 18:44:33 CDT












Original text of this message













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