DEV Community

rohitrkr
rohitrkr

Posted on

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

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

Top comments (0)