help with query

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Fri, 4 Aug 2000 07:42:08 -0700 (PDT)
Message-Id: <10579.113854@fatcity.com>

Hi all,

Here is the data..

id date amount

1      15-jul-00    100
1      15-jul-00     50
1      15-jul-00     200  <<<<<<<<
2      15-jul-00    50
2      15-jul-00    100   <<<<<<<<

I need to get a row with max(date) (Date field is with time so we can get last row that was inserted) for each user..

so my output should be

1      15-jul-00   200
2      15-jul-00   100

Any idea??

TIA

---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Fri Aug 04 2000 - 09:42:08 CDT