Select (Get) last two hours records from database table in SQL Server

Hi rani

Refer below sample query.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

SELECT *
FROM Employees
WHERE [BirthDate] >= DATEADD(HOUR, -2, GETDATE()) AND [BirthDate] <= GETDATE()
ORDER BY [BirthDate] ASC

-- OR
SELECT *
FROM Employees
WHERE [BirthDate] BETWEEN DATEADD(HOUR, -2, GETDATE()) AND GETDATE()
ORDER BY [BirthDate] ASC