Message-Id: <10579.113854@fatcity.com> From: Ashish Shah Date: Fri, 4 Aug 2000 07:42:08 -0700 (PDT) Subject: help with query 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.