 |
 |
 |
| SQL Advanced | |||
| SQL IN | |||
| IN | |||
| The IN operator may be used if you know the exact value you want to return for at least one of the columns. | |||
|
|||
| Original Table (used in the examples) | |||
|
|||
| Example 1 | |||
| To display the persons with FirstName equal to "niidhi” or ”Deepti” use the follwing sql statement. | |||
|
|||
| Result: | |||
|
|||
|
|||