Re: sql question

From: dharma <ajdharmaraj_at_gmail.com>
Date: 25 May 2005 13:10:04 -0700
Message-ID: <1117051804.447191.202460@f14g2000cwb.googlegroups.com>

If you dont want to use analytics, you can use the old way

SELECT col1,

       col2,
	   (MAX(DECODE(col3,'s',val)) - MAX(DECODE(col3,'k',val))) /

MAX(DECODE(col3,'p',val)) val
FROM TBL1
GROUP BY col1,col2
HTH cazman wrote:
> Hi David,
>
> I'm on Oracle 9.2 and your query doesn't work. I'll try to work
> something around it.
>
> Thanks for your help.
Received on Wed May 25 2005 - 15:10:04 CDT