I have an excel file with data of about 1000 records. I want to read each employees temperature of 5 consecutive days. If it is greater than 100 for 5 continuous days, I have to return this employee's data. Can anyone help me to query this is SQL? Thanks in advance!
SELECT reading_date, employeeID FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY EmployeeID ORDER BY Temperature DESC) AS reading_date,* FROM TEMP_READINGS ) as readings WHERE readings.EmployeeID = 5 AND readings.reading_date<= 5
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)