| Start |
|---|
Test Data Below is the output of above table,As you can see Id Column is repeated three times.. Now Lets check the output using simple order by.. Output :(Output of above query is not guaranteed to be same every time ) Lets run the Same query With Ties Option.. Output : As you can see SQL Server outputs all the Rows which are tied with Order by Column. Lets see one more Example to understand this better.. Output: In Summary ,when we use with Ties Option,SQL Server Outputs all the Tied rows irrespective of limit we impose |
Read Article
https://develop.horje.com/learn/1434/reference