I am new to SQL programming. What I want to do is return an entire row from a table, based on the fact that that row has the maximum value for a particular column. Something like:
SELECT * FROM table where field = max(field)
Obviously, this statement doesn't work, because this is SQL, and nothing is simple or intuitive with SQL it seems.
Can anyone set me on the right track?
Edit : I guess I missunderstood something, if you want single row based on max value
Original post :
Hi you can do followings -
If you are using sql Server 2005/2008
For Sql Server 2000
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?