One of the new enhancements in SQL 2005 provides the ability to do Data Manipulation using "TOP" clause and returning similar criteria results that use the TIES option. This article illustrates the new enhancements of the TOP clause in SQL 2005.

This story continues at http://databasejournal.com/features/...le.php/3532226