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

Vikas Kumar

5y931

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
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
+1
Vikas Kumar5y ago
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.
+1
Jignesh Kumar5y ago
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
+2
Salman Beg5y ago
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
+1