How to Select LAST N Row in SQL Server

You can use this query to get last N records

SELECT TOP(N) *
FROM TableName
ORDER BY Table_ID DESC

OR

simply use this query syntax to get last N records

 select * from table_name except select top 
 (numbers of rows - how many rows you want)* from table_name

So for example, I have a table with total 7 rows, to get last 2 records in SQL Server, query would be as below:

select * from [OrderDetails].[dbo].[EmployeeSalary] except select top 
(7 - 2)* from [OrderDetails].[dbo].[EmployeeSalary]

If you don't know how many total records are there in table

select * from [AdventureWorks2012].[Production].[Product] 
except 
select top 
 ((SELECT COUNT(*) FROM [AdventureWorks2012].[Production].[Product]) - 2)
 * from [AdventureWorks2012].[Production].[Product]

That should also work.

OR

In SQL Server 2012 or above try this

SELECT *
FROM  <Your_Table> As LR
ORDER BY LR.<your Field>
OFFSET <@TableRowsCount-@N> ROWS
FETCH NEXT @N ROWS ONLY;

It will also work.