![SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 - SQL Authority with Pinal Dave SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ViewLimit1.jpg)
SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 - SQL Authority with Pinal Dave
![Use ROLLUP with ORDER BY clause moves the Grand Total row from the bottom to the top - Stack Overflow Use ROLLUP with ORDER BY clause moves the Grand Total row from the bottom to the top - Stack Overflow](https://i.stack.imgur.com/q5iO6.png)
Use ROLLUP with ORDER BY clause moves the Grand Total row from the bottom to the top - Stack Overflow
![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
![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 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/tTAYX.png)