How to remake the SQL query so that it returns data for the last 5 minutes from the current time?

Question

SQL Server

Query to MSSQL

SELECT TOP 1 TimeVal,Remark FROM pLogData WHERE Remark LIKE "%Тревога%" ORDER BY TimeVal DESC

gives out 2018-10-05 13:44:21.000 Тревога дверь 1
how you can redo the request so that it gives out only data for the last 5 minutes

Answer 1

Obviously subtract 5 minutes from the current date and compare the result with the date of the entries

SELECT TimeVal,Remark FROM pLogData 
WHERE Remark LIKE "%Тревога%" AND TimeVal >= DATEADD(minute,-5,GETDATE()) ORDER BY TimeVal DESC