Posted by Alexander Kuznetsov on 09/29/05 22:57

another way:

select a.account,a.balance_date,a.balance
from a
where not exists
(select 1
from a a1
where a.account =a1.account
and a.balance_date <a1.balancedate )

• Next in forum: Re: Controlling fields in a select statement by use of parameters
• Prev in forum: Autogrow question
• Thread view: Re: Query Help, thanks!

[Reply to this message]