![How Does TOP WITH TIES Work in SQL Server? - Interview Question of the Week #159 - SQL Authority with Pinal Dave How Does TOP WITH TIES Work in SQL Server? - Interview Question of the Week #159 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/d/topwithties3.png)
How Does TOP WITH TIES Work in SQL Server? - Interview Question of the Week #159 - SQL Authority with Pinal Dave
![sql server - SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange sql server - SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange](https://i.stack.imgur.com/LH8B3.png)
sql server - SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange
![SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/unionall.gif)