Posts Tagged ‘top records’


Not many people seem to be aware of the WITH TIES clause introduced in SQL Server 2005+. This simple feature is worth adding to your query armoury. In the words of BOL WITH TIES… “Specifies that additional rows be returned from the base result set with the same value in the ORDER BY columns appearing […]