query needed

[narendraTV]

I have a table like this:

n users can make 'n' number of transactions.

USER_ID RPT_NO RPT_DATE DD_AMOUNT
---------- ---------- ------------------ ------------
203 1313 12-SEP-07 20000
203 13333 22-SEP-07 500
203 333 14-SEP-07 20000
203 22222 13-SEP-07 20000
202 1212 12-SEP-07 19000
203 77 07-JUL-07 900
202 1211 10-SEP-07 19000
202 1234 11-SEP-07 1000

i need the most recent DD_AMOUNT for each user as follows:(for abouve Ex)

USER_ID RPT_NO RPT_DATE DD_AMOUNT
---------- ---------- ------------------ ------------
202 1212 12-SEP-07 19000
203 13333 22-SEP-07 500

[debasisdas]

Kindly post the query that you have tried to solve this problem, to get more help from the experts of the forum.