How to fetch records which stored in last 5 minutes in sql server

Question

I have a table which stores temperature data from iot device in sql server. I need a stored procedures which return true if same temperature stored in last 5 minutes else false.

Jignesh Kumar · Answer

Hi Vikas, Please do changes as per your table name and column name, create PRocedure Usp_IsSameTempratureExists @Tempuratue decimal (10,2) As Begin Declare @isExists bit if Exists( select YourIdCoulmn from YourTableName where CreatedDateColumn is not null and CreatedDateColumn > DATEADD( MINUTE , -5, GETDATE()) and Tempuraturecolumn = @Tempuratue) Begin set @isExists = 1; End Else Begin set @isExists = 0; End select @isExists End

Jignesh Kumar · Answer

Yes it will retun 0 if data is not exists and it will return 1 means true for provided temprature. You can test store procedure using exec Usp_IsSameTempratureExists 50

Vikas Kumar · Answer

Will is return false. If another temperature degree comes in last 5 minutes. Like if I pass 50.0 and if data inserted 50.0 for 2 minutes and after 2 minutes another data inserted which is 55.0 and in another 4 minutes 45.0 inserted.In that case Data has changed multiple times but I need true if only same data inserted in last 5 minutes otherwise false.

Salman Beg · Answer

Check this link, https://stackoverflow.com/questions/59339576/sql-how-to-fetch-the-last-5-minutes-of-data https://stackoverflow.com/questions/23228133/how-can-query-last-5-minutes-of-records/23229525