Finding missing values from a sequence in a SELECT statement

I'm kinda clueless about how to write a strange (at least for me!) SELECT statement. I'm new to SQL and I'm not even sure what I'm trying to do makes sense... Let's say I have the given table :

 ID_NUMBER --------- 1 2 3 5 6 8

Is there any simple way to have a table returned with the missing values of ID_NUMBER from the sequence of [1-8] to obtain the following table?

 ID_NUMBER --------- 4 7

Any help would be appreciated!

asked Jun 3, 2013 at 0:49

user1311189

4

use a 'Numbers' table (also called a tally table)

Mitch Wheat
– Mitch Wheat

2013-06-03 00:49:50 +00:00
Commented Jun 3, 2013 at 0:49
You can use WINDOW functions if your database supports it. Take a look at this question stackoverflow.com/questions/7974866/…

gkamal
– gkamal

2013-06-03 01:03:05 +00:00
Commented Jun 3, 2013 at 1:03
Generally you need to create a table and do an OUTER JOIN against it

Old Pro
– Old Pro

2013-06-03 01:05:04 +00:00
Commented Jun 3, 2013 at 1:05

Add a comment |

Collectives™ on Stack Overflow

Finding missing values from a sequence in a SELECT statement [duplicate]

0

Linked

Hot Network Questions