Steffen Mangold wrote: > TimeStamp | Status > ------------------------------------------------- > 2012-07-24 22:23:00 | status1 > 2012-07-24 22:23:05 | status1 > 2012-07-24 22:23:10 | status2 > 2012-07-24 22:23:16 | status2 > 2012-07-24 22:23:21 | status1 > 2012-07-24 22:23:26 | status1 > 2012-07-24 22:23:32 | status2 > 2012-07-24 22:23:37 | status3 > 2012-07-24 22:23:42 | status3 > 2012-07-24 22:23:47 | status3 > > This is what I want: > > Begin | End | Status > --------------------------------------------------------------------------- > 2012-07-24 22:23:00 | 2012-07-24 22:23:05 | status1 > 2012-07-24 22:23:10 | 2012-07-24 22:23:16 | status2 > 2012-07-24 22:23:21 | 2012-07-24 22:23:26 | status1 > 2012-07-24 22:23:37 | 2012-07-24 22:23:47 | status3
And what about the event at 22:23:32? Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
