Selecting bottom 10 results

Question

If I recall there is no bottom command in SQL server only top. If I want the bottom 10 results I need to sort ascending order or use that new offset command. Would that be correct?

Answer 1

Hi @Jonathan Brotto ,

Check it out.

DECLARE @tbl TABLE (ID INT);  
INSERT @tbl (ID) VALUES  
(1),(2),(3),(4),(5);  
  
-- select top 2  
SELECT TOP(2) *   
FROM @tbl  
ORDER BY ID ASC;  
  
-- select last 2  
SELECT TOP(2) *   
FROM @tbl  
ORDER BY ID DESC;  

Answer 2

Hi ,
Thanks for reaching out, yes, you have to use subquery to get the top value and short it to DESC and and then change it to ASC order (This is one way of doing, you can write your own suitable query)

SELECT
columns
FROM
(
SELECT TOP 10
columns
FROM
My_Table
ORDER BY
column_name DESC
) SQ
ORDER BY
column_name ASC

Hope this helps,

thanks