Wednesday 29 May 2013

IN Condition

Use the IN membership condition to test for values in a list.

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