Still too new to SQL to have run across this yet ...
How does one return the latest row from a table, given multiple entries of varying data?
i.e.: given a table that looks like this:
color | date --------+------------ red | 2004-01-19 blue | 2004-05-24 red | 2004-04-12 blue | 2004-05-24
How do I select the most recent entry for 'red'?
Thanks in advance! Scott
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
