If you have a table of incremental values it can be hard to find out which ones are missing. The only solution might be to write a script to get all the data from the database and see which ones are missing. However, there is a way of doing this without using a script.
Using a standard select query like this:
SELECT * FROM TABLE;
Gets the following data:
We can see that values are missing, but which ones? The following query will show us where the gaps are in the data of the table.