Re: Complex PL-SQL Query ?

From: Damjan S. Vujnovic <damjan_at_galeb.etf.bg.ac.yu>
Date: Thu, 21 Nov 2002 09:42:30 -0800
Message-ID: <aria5u$8el$1@news.etf.bg.ac.yu>

"Jusung Yang" <JusungYang_at_yahoo.com> wrote:
> > YDT 5 443322/B 01-JAN-99
> > YTD 5 443322/B 28-NOV-02
>
> Should the first be 'YTD'? If yes, you can do something like this:
>
> select * from <table> t1 where exists ( select * from
> (select HULLTYPE, max(ASOFDATE) d1 from <table> group by ASOFDATE)
t2
> where t1.HULLTYPE=t2.HULLTYPE and t1.ASOFDATE=t2.d1);

[group by ASOFDATE] or maybe [group by HULLTYPE]?

Regards,
Damjan S. Vujnovic

University of Belgrade
School of Electrical Engineering
Department of Computer Engineering & Informatics Belgrade, Yugoslavia

http://galeb.etf.bg.ac.yu/~damjan/ Received on Thu Nov 21 2002 - 11:42:30 CST