Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql get missing id

SELECT DISTINCT id +1
FROM mytable
WHERE id + 1 NOT IN (SELECT DISTINCT id FROM mytable);
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #missing #id
ADD COMMENT
Topic
Name
6+2 =