find missing numbers in table using sql

[g_amol]

hi i am new to sql soplz give me idea about it how to find missing numbers which is given in table using sql query, e.g. i/p 1 2 3 4 5 6..... for query 1 2 5 8 o/p???????? 3 4 6 7 how it coes by query plz tellme any body

[Niladri_Biswas]

Try this declare @Table1 table(id int) insert into @Table1 select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 declare @Table2 table(id int) insert into @Table2 select 1 union all select 2 union all select 5 union all select 8 Solution 1:

select id from @Table1 except select id from @Table2

Solution 2:

select id from @Table1 where id not in (select id from @Table2)

Let me know in case of any concern :)

Niladri Biswas