Re: Query Help, thanks!

From: "SQL" <denis.gobo@xxxxxxxxx>
Date: 29 Sep 2005 10:55:24 -0700

Here is one way
select a.account,a.balance_date,a.balance
from
(select account,max(balance_date) as balancedate
from a
group by account)aTemp join a on a.account =aTemp.account
and a.balance_date =aTemp.balancedate

http://sqlservercode.blogspot.com

.

References:
- Query Help, thanks!
  - From: rong . guo

Prev by Date: Query Help, thanks!
Next by Date: Re: Query Help, thanks!
Previous by thread: Query Help, thanks!
Next by thread: Re: Query Help, thanks!
Index(es):
- Date
- Thread