Performing calculation using two rows from the same table

[mamin]

I have a table that contains file name, file seq num, etc. I would like to compare the two rows to make sure the file seq num is being incremented by one or more. If it is incremented >1 then I l know that there is a file missing.

[iburyak]

Try this:

[PHP]select sequence
from table a
where not exists(select sequence from table where sequence = a.sequence + 1)[/PHP]

Good Luck.

[mamin]

Try this:

[PHP]select sequence
from table a
where not exists(select sequence from table where sequence = a.sequence + 1)[/PHP]

Good Luck.

Thank you. I will try that.