Could you not do this: Select A.time + 1 minute, B.time - 1 minute from log as A, log as B where A.RowID=B.RowID+1 and B.time-A.time > 1 minute
Tom -----Original Message----- From: Andrew Lindsay Sent: Wednesday, April 20, 2011 7:34 PM To: sqlite-users@sqlite.org Subject: [sqlite] Request for help with SQLite Query to return missingDate/Time Ranges Dear Group, I am trying to search an SQL database that is meant to have entries logged every minute for a period of approximately 15 months. I want to create a query that will search through the database and tell me for which periods I do not have any entries. Any assistance would be greatly appreciated. Regards Andrew Lindsay _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users