Posted by rong.guo on 09/29/05 23:04

THANKS!

Alexander Kuznetsov wrote:
> 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: NAMED SET / PIVOT TABLE !! HELP ME
• Prev in forum: Re: Controlling fields in a select statement by use of parameters
• Thread view: Re: Query Help, thanks!

[Reply to this message]