| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Scott Hamm | Date: | August 18 2005 12:59pm |
| Subject: | Deleted rows | ||
| View as plain text | |||
If I got a table as follows:
ID foo
1 12345
2 12346
4 12348
6 12349
7 12388
9 12390
How do I execute a query that shows missing ID's like so:
3
5
8
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?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
| Thread | ||
|---|---|---|
| • Deleted rows | Scott Hamm | 18 Aug |
| • Re: Deleted rows | SGreen | 18 Aug |
| • Re: Deleted rows | Peter Brawley | 18 Aug |
| • Re: Deleted rows | SGreen | 18 Aug |
| • Re: Deleted rows | Scott Hamm | 18 Aug |
| • Re: Deleted rows | Peter Brawley | 18 Aug |
| • RE: Deleted rows | emierzwa | 18 Aug |
