select * from rates where cast(dt as char(11))=(select max(cast('Mar 13 2007' as char(11))) from rates) order by dt descThe ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
Chamber of Commerce, Hapur