Re: Oracle SQL query - Grouping function to take 1st value for non-grouped cols

From: Björn Wächter <Bjoern.Waechter_at_p3-solutions.de>
Date: Fri, 9 Sep 2005 10:08:13 +0200
Message-ID: <3ocu9cF5dcesU1@news.dfncis.de>

This query should do the Job:

SELECT
DEPARTMENT,

MIN(JOB)         KEEP (DENSE_RANK FIRST ORDER BY ROWNUM) JOB,
MIN(TOTAL_EMPL)  KEEP (DENSE_RANK FIRST ORDER BY ROWNUM) TOTAL_EMPL,
MIN(AVERAGE_SAL) KEEP (DENSE_RANK FIRST ORDER BY ROWNUM) AVERAGE_SAL

FROM AAAA
GROUP BY DEPARTMENT But I think its better idea to use another column for the ORDER BY clause. Received on Fri Sep 09 2005 - 03:08:13 CDT