![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
![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
All about SQLServer: SQL Server access Previous / Next rows and first / last row from partitioned resultset
![SQL SERVER - Return Specific Row to at the Bottom of the Resultset - T-SQL Script - SQL Authority with Pinal Dave SQL SERVER - Return Specific Row to at the Bottom of the Resultset - T-SQL Script - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/orderbycase.jpg)