|
|
Posted by rong.guo on 09/29/05 20:44
Greetings!
Please see my data below, for each account, I would need the lastest
balance_date with the corresponding balance. Can anyone help me with
the query? Thanks a lot!
create table a
(account int
,balance_date datetime
,balance money)
insert into a values(101,'1/31/2005', 5000)
insert into a values(101,'2/28/2005', 6000)
insert into a values(102,'5/31/2005', 15000)
insert into a values(102,'6/30/2005', 10000)
Ideal Output
101 '2/28/2005' 6000
102 '6/30/2005' 10000
Navigation:
[Reply to this message]
|