SQL: find missing IDs in a table

by

I landed on this page hoping to find a solution for SQLITE as this was the only answer I found when searching for this same question for SQLITE.

The final solution I found was from this article here
Float Middle Blog – SQLITE answer

Hope it helps someone else out 🙂

the simple solution being:

SELECT DISTINCT id +1
FROM mytable
WHERE id + 1 NOT IN (SELECT DISTINCT id FROM mytable);

genius.

More Related Contents:

  1. How to find the common values from two different tables having a common column
  2. Should I use != or for not equal in T-SQL?
  3. Any downsides of using data type “text” for storing strings?
  4. Can I pass column name as input parameter in SQL stored Procedure
  5. Foreign Key to non-primary key
  6. Query for array elements inside JSON type
  7. Calculating Cumulative Sum in PostgreSQL
  8. “CASE” statement within “WHERE” clause in SQL Server 2008
  9. SQL Server – How to lock a table until a stored procedure finishes
  10. How to create a unique index on a NULL column?
  11. Serial numbers per group of rows for compound key
  12. What happens to an uncommitted transaction when the connection is closed?
  13. Create Trigger to log SQL that affected table?
  14. Difference between datetime and timestamp in sqlserver? [duplicate]
  15. How to count instances of character in SQL Column
  16. “IN” clause limitation in Sql Server
  17. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  18. Postgres not using index when index scan is much better option
  19. Check if current date is between two dates Oracle SQL
  20. convert Postgres geometry format to WKT
  21. SQL query that gives distinct results that match multiple columns
  22. SQL Server Convert integer to binary string
  23. create custom function for date difference excluding weekends and holidays in oracle sql
  24. Using a database table as a queue
  25. Passing dynamic order by in stored procedure
  26. Group consecutive rows of same value using time spans
  27. Linq to SQL: How do I stop the auto generated object name from being renamed?
  28. Using django how can I combine two queries from separate models into one query?
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. SQL add filter only if a variable is not null

Leave a Comment