| Write down a SQL Query to find the missing number in Auto increment column?
There are certain situation when some number are missed in auto increment column to get that number we use below query:-
select l.id + 1 as start
from tblname as l
left outer join tblname as r on l.id + 1 = r.id
where r.id is null;
| | |