Write down a SQL Query to find the missing number in Auto increment co

1.	Write down a SQL Query to find the missing number in Auto increment column?
Answer» 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;

Discussion