Select row with Max Value
Hi
Say I have a table with the following -
id-----------date-------------value
001----01-01-2010-------50
002----01-01-2010-------52
003----01-01-2010-------51
004----01-01-2010-------62
I want to get the id, date and value of the row with the max value...
id-----------date-------------value
004----01-01-2010-------62
Using select max(value) from table, only gives me the value 62, I want to know the id and date for that row aswell.
Whats the easiest and best way to get this?