query to find the values which are not in IN clause [message #355025] |
Wed, 22 October 2008 05:29  |
jyothsna1612
Messages: 68 Registered: June 2008
|
Member |
|
|
Hi,
I need to find the values which are not in IN clause:
for ex:
SQL> select sal from emp where sal in(800,100);
SAL
----------
800
In the above ex: 100 is not in the emp table's sal column
Like that for thousands of rows i need to find that value which are not in the table but unknowingly typed in IN clause
Means in this example i need to get the output 100
How can that be achieved??
|
|
|
|
|
|
|
|
|
|
|
|
|