Use the IN membership condition to test for values in a list.
Example:
The above example displays employee no, name, salary, deptno from emp table for all employees whose salary is 1000,2000,3000, or 5000.
The IN condition can be used with any datatype.
Example:
Example:
To test for values in a specified set of values, use the IN condition. The IN condition is also known as the "membership condition"
The above example displays employee no, name, salary, deptno from emp table for all employees whose salary is 1000,2000,3000, or 5000.
The IN condition can be used with any datatype.
Example:
No comments:
Post a Comment