Well I could order by ID then date but would still need to program sql to retrieved the first or last row for each ID. Wouldnt I need to write some PL-SQL to do that? I have less PL-SQL knowledge than I have of Perl, which is sad I know... :(
You original post states that you want to keep the row with the most recent date. Something like the SQL MAX statement might do the trick. What SQL server are you using?