if i have the following table...i want to return the latest results.
is it possible?

e.g.
ID Action Date
a1 jump 2/9/2008
a2 walk 3/9/2008
j10 jump 3/9/2008
a1 move 3/9/2008
a2 climb 5/9/2008


I want to have follow results...

ID Action Date Latest_action Latest_Date
a1 jump 2/9/2008 move 3/9/2008
a2 walk 3/9/2008 climb 5/9/2008
j10 jump 3/9/2008 jump 3/9/2008
a1 move 3/9/2008 move 3/9/2008
a2 climb 5/9/2008 climb
5/9/2008