O'Reilly logo
  • Dustin Waybright thinks this is interesting:

SELECT TOP (3) WITH TIES orderid, orderdate, custid, empid FROM Sales.Orders ORDER BY orderdate DESC;


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Will return all rows that have equal values in the ORDER BY columns to the last row in the original TOP selection.