![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 - 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
How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio? | Schneider Electric Malaysia
![Sql Server : How to SELECT BOTTOM to records (vs TOP 10 records) maintaining the same order in records | Playing with database servers... Sql Server : How to SELECT BOTTOM to records (vs TOP 10 records) maintaining the same order in records | Playing with database servers...](https://sqltimes.files.wordpress.com/2017/06/botom_5_result.png)