Re: Using Analytics......

From: Jörg Menker <jmenker_at_muenster.de>
Date: 24 Feb 2006 05:56:16 -0800
Message-ID: <1140789376.510599.143680@i39g2000cwa.googlegroups.com>

How about a solution without using analytics like this one?

SELECT MAX(CASE WHEN A.MIN_SP2 = B.SP2 THEN B.SP1 END) MIN_SP1,

       MAX(A.MIN_SP2) MIN_DATE,
	   MAX(CASE WHEN B.SP2 = A.MAX_SP2 THEN B.SP1 END) MAX_SP1,
	   MAX(A.MAX_SP2) MAX_DATE,
       MAX(A.ANZ) CNT
FROM   (SELECT MIN(SP2) MIN_SP2,
               MAX(SP2) MAX_SP2,
               COUNT(*) ANZ
        FROM   TEST_QUERY) A,
       TEST_QUERY B
WHERE  A.MIN_SP2 = B.SP2
OR     A.MAX_SP2 = B.SP2

Regards,

Jörg Received on Fri Feb 24 2006 - 07:56:16 CST