Help with group by function
From: Tom Deseamus <tdeseamus_at_digital-hire.com>
Date: Mon, 28 Feb 2000 11:09:51 -0800
Message-ID: <GYxu4.2988$Jh3.29519_at_news3.mia>
[Quoted] [Quoted] Can anyone tell me why this will not compile as a view.
Date: Mon, 28 Feb 2000 11:09:51 -0800
Message-ID: <GYxu4.2988$Jh3.29519_at_news3.mia>
[Quoted] [Quoted] 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 - 20:09:51 CET