I am recording data received over a serial bus into a sqlite database. The data is received at roughly 40hz, though some variables are in less frequent multiples of that, 10hz and 4hz.
Variable, Value, Time Speed, 60, 0.1ms Direction, 90, 0.4ms Temp, 22, 0.7ms Speed, 60, 25ms Speed, 60.21, 50ms Speed, 60.55, 75ms Speed, 60, 100.1ms Direction, 90, 100.4ms Speed, 60, 125ms Speed, 60.21, 150ms Speed, 60.55, 175ms Speed, 60, 200.1ms Direction, 90, 200.4ms Speed, 60, 225ms Speed, 60.21, 250ms Direction, 90, 250.4ms Temp, 22, 250.7ms I would like to pivot the table into groups of 40hz data and get Time, Speed, Direction, Temp 0-25, 60, 90, 22 25-50, 60, null, null 50-75, 60.21, null, null 75-100, 60.55, null, null 100-125, 60, 90, null 125-150, 60, null, null 150-175, 60.21, null, null 175-200, 60.55, null, null 200-225, 60, 90, null 225-250, 60, null, null 250-275, 60.21, 90, 22 Is there a good way to do this with Select and Group By statement? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
