![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)
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - 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 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/topwithties1.png)
How Does TOP WITH TIES Work in SQL Server? - Interview Question of the Week #159 - SQL Authority with Pinal Dave
![How to get Top / Bottom N Records from SQL Server Table in SQL Server - TSQL Tutorial Part 113 - YouTube How to get Top / Bottom N Records from SQL Server Table in SQL Server - TSQL Tutorial Part 113 - YouTube](https://i.ytimg.com/vi/-jHjTQ2vHmk/hqdefault.jpg)
How to get Top / Bottom N Records from SQL Server Table in SQL Server - TSQL Tutorial Part 113 - YouTube
![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/unionall1.gif)
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave
![SQL SERVER - SELECT TOP Shortcut in SQL Server Management Studio (SSMS) - SQL Authority with Pinal Dave SQL SERVER - SELECT TOP Shortcut in SQL Server Management Studio (SSMS) - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/shortcut1.jpg)