Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using Analytics......
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