DEV Community

loading...

how to get the data of 10-10 row as a single row through sql querry among large set of data?

rohitrkr
・1 min read

I have a table that consist of multiple data of same ID with different-different time stamp(each interval of 6 minutes) in one column, and its redcorded temperature at each given time stamp.

ID Time_Stamp Temperature_1 Temperature_2
101 18-09-2020 17:05:40 98.50 87.63
101 18-09-2020 17:11:40 96.60 46.3
101 18-09-2020 17:17:40 80.50

Discussion (0)