Thank this author by sharing:
By Aryaman Panwar, 2012/07/30
you can change the order in, in clause and find that order max and min value easily.
This is simplest query that is easy to use and learn. there is no need extra effort to learn it.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com