Re: SQL query problem

From: sim <jmenker_at_muenster.de>
Date: 23 Jan 2006 07:35:02 -0800
Message-ID: <1138030502.494917.290550@g47g2000cwa.googlegroups.com>

Hello Mike,

you could try this one:

CREATE TABLE TEST_MEJ2 (PERSON VARCHAR2(20),FRUIT VARCHAR2(20)) TABLESPACE VC_DATEN INSERT INTO TEST_MEJ2 VALUES('BOB', 'APPLE'); INSERT INTO TEST_MEJ2 VALUES('TOM', 'KIWI'); INSERT INTO TEST_MEJ2 VALUES('JIM', 'PEACH'); INSERT INTO TEST_MEJ2 VALUES('BOB', 'KIWI'); INSERT INTO TEST_MEJ2 VALUES('TOM', 'PEAR'); INSERT INTO TEST_MEJ2 VALUES('JIM', 'APPLE'); SELECT A.PERSON
FROM
(

SELECT	PERSON,
		SUM(CASE WHEN FRUIT = 'APPLE' THEN 100
		     WHEN FRUIT = 'PEACH' THEN 1000
		     ELSE 0
		END) FRUIT_VAL
FROM	TEST_MEJ2

GROUP BY PERSON
) A
WHERE A.FRUIT_VAL = 0 Row# | PERSON
1 TOM Regards,

sim Received on Mon Jan 23 2006 - 09:35:02 CST