Click here to Skip to main content
15,891,136 members

How to use NOT IN operator

Revision 2
Here is my table

Table1

ID Sequence
1 1
1 3
1 4
1 6
1 8
1 10

and i want this following output
2
5
7
9

I've tried this
SQL
SELECT Sequence FROM Table1 WHERE Sequence NOT IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10') and ID ='1'

but it not works.
Posted 12-Nov-12 22:46pm by sahabiswarup.
Tags: