with ties
TOP clause in T-SQL
Using TOP in T-SQL select given number of rows. It limits the rows returned in a query result set.
Let begin with TOP clause ... be use only in SELECT statement and with ORDER BY clause. The TOP is used in SELECT, INSERT, UPDATE, DELETE, MERGE statement.