Re: Help with group by function
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 Feb 2000 18:27:26 +0100
Message-ID: <951760293.20788.0.pluto.d4ee154e_at_news.demon.nl>
Date: Mon, 28 Feb 2000 18:27:26 +0100
Message-ID: <951760293.20788.0.pluto.d4ee154e_at_news.demon.nl>
Try
SELECT Max(H.FROM_DATE) AS MaxOfFROM_DATE, E.APPLICANT_ID
FROM JOB_HISTORY H, EMPLOYMENT_DETAIL E
where E.EMPLOYMENT_DETAIL_ID = H.EMPLOYMENT_DETAIL_ID
GROUP BY E.APPLICANT_ID
Having allows group functions (count, sum) only
Hth,
Sybrand Bakker, Oracle DBA
Tom Deseamus <tdeseamus_at_digital-hire.com> wrote in message
news:GYxu4.2988$Jh3.29519_at_news3.mia...
> Can anyone tell me why this will not compile as a view.
>
>
> SELECT Max(H.FROM_DATE) AS MaxOfFROM_DATE, E.APPLICANT_ID
> FROM JOB_HISTORY H, EMPLOYMENT_DETAIL E
> GROUP BY E.APPLICANT_ID
> HAVING E.EMPLOYMENT_DETAIL_ID = H.EMPLOYMENT_DETAIL_ID
>
>
Received on Mon Feb 28 2000 - 18:27:26 CET