The IN operator may be used if you know the exact value you want to return for at least one of the columns.

Submitted by: Administrator
SELECT column_name FROM table_name WHERE column_name IN (value1,value2,..)
Submitted by: Administrator

Read Online SQL and PL/SQL Job Interview Questions And Answers