>How do I execute a query that shows missing ID's like so:
SELECT id AS i
WHERE i <> 1 AND NOT EXISTS(
SELECT id FROM tbl WHERE id = i - 1
Scott Hamm wrote:
If I got a table as follows:
How do I execute a query that shows missing ID's like so:
I wouldn't expect for it to show deleted data that was deleted, just show
the "skipped" ID's.
That way I determine if operator deleted too much (cheating at QC)
Is it possible?
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005