![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
![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/wp-content/uploads/2008/03/unionall1.gif)
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave
![Sunday T-SQL Tip: select top N using aligned non-clustered index on partitioned table | About Sql Server Sunday T-SQL Tip: select top N using aligned non-clustered index on partitioned table | About Sql Server](http://aboutsqlserver.com/blog/2011-12-18/pic2.png)
Sunday T-SQL Tip: select top N using aligned non-clustered index on partitioned table | About Sql Server
![How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com](http://dev.mytechmantra.com/wp-content/uploads/2019/07/Select-Top-n-Rows-and-Edit-Top-n-Rows-Default-Value-in-SQL-Server-Management-Studio.png)
How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com
![How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com](http://dev.mytechmantra.com/wp-content/uploads/2019/07/Specify-the-new-value-for-Value-for-Edit-Top-n-Rows-Command-and-Specify-the-Value-for-Select-Top-n-Rows-Command.png)