select a.*
from tablename a left join
( select id-1 from tablename ) b
on a.id=b.id
where b.id is null and a.id <> (select max(id) from tablename)
from tablename a left join
( select id-1 from tablename ) b
on a.id=b.id
where b.id is null and a.id <> (select max(id) from tablename)
where b.id is null and a.id <> (select max(id) from test)