Re: Tough SQL - min, max driven

From: sim <jmenker_at_muenster.de>
Date: 14 Oct 2005 05:29:21 -0700
Message-ID: <1129292961.945884.188400@z14g2000cwz.googlegroups.com>

This one is at least a bit shorter:

		 Z.SUBURB_NAME,
		 TO_CHAR(X.MIN_TIME,'DDMonYYYY'),
		 TO_CHAR(X.MAX_TIME,'DDMonYYYY'),
		 Z.PRIORITY,
		 Z.JOB_TYPE,
		 Z.STATUS
FROM
         (
         SELECT	 A.POSTCODE,
         		 A.SUBURB_NAME,
         		 MIN(A.START_TIME) MIN_TIME,
         		 MAX(A.END_TIME) MAX_TIME,
         		 MIN(A.PRIORITY) MIN_PRIO
         FROM	 TEST_TABLE01 A
         GROUP BY A.POSTCODE,
         	  	 A.SUBURB_NAME
         ) X,
         TEST_TABLE01 Z
WHERE Z.POSTCODE = X.POSTCODE
AND	  Z.SUBURB_NAME = X.SUBURB_NAME
AND	  Z.PRIORITY = X.MIN_PRIO

sim Received on Fri Oct 14 2005 - 07:29:21 CDT