"WITH TIES" is a case of TOP:
SELECT TOP N WITH TIES ...
FROM Table Name ORDER BY ColumnA
WITH TIES Specifies that additional rows (more than N) be returned from the base result set with the same value of the last of the TOP N.
Example:
Top 3 - returns exactly 3 records. Which one from the 4 records that can be chosen? who knows...
Top 3 With Ties - returns with the third record all the appropriate records.
Notes:
- WITH TIES can return more than N records. It's important to remember it.
- WITH TIES is used only with ORDER BY clause. If we don't use the ORDER BY clause an error will be generated.
No comments:
Post a Comment