|
|
Posted by SQL on 09/29/05 20:55
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
Navigation:
[Reply to this message]
|