tag:blogger.com,1999:blog-29286778.post5452238831176617552..comments2007-08-05T00:45:58.938-04:00Comments on SQL Garbage Collector: Obvious SQL Tip #1Omnibuzzhttp://www.blogger.com/profile/04342835880399785393noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-29286778.post-37044285947396344742007-08-05T00:45:00.000-04:002007-08-05T00:45:00.000-04:00select top 1<br> OrderID,<br> Custom...select top 1<BR/> OrderID,<BR/> CustomerID,<BR/> EmployeeID,<BR/> MAX(OrderDate),<BR/> MAX(freight)<BR/>from orders<BR/>group by OrderID,<BR/> CustomerID,<BR/> EmployeeID<BR/>Order by MAX(freight) DESC, MAX(OrderDate) DESCAnonymousnoreply@blogger.com