Sql of note/Pivoting in sql

From Federal Burro of Information
< Sql of note
Revision as of 21:30, 7 November 2018 by David (talk | contribs) (Created page with " thdata: <pre> sqlite> select * from thedata limit 10; collecttime|sensor1|sensor2 1525694702|685|255 1525695002|694|262 1525695302|706|267 1525695602|706|269 1525695902|700|...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

thdata: 

sqlite> select * from thedata limit 10;
collecttime|sensor1|sensor2
1525694702|685|255
1525695002|694|262
1525695302|706|267
1525695602|706|269
1525695902|700|267
1525696202|700|266
1525696502|697|264
1525696802|695|261
1525697102|694|259
1525697402|698|261
Retrieved from "https://wiki.quadratic.net/index.php?title=Sql_of_note/Pivoting_in_sql&oldid=4022"