DML-select-In:

nThe IN operator allows you to specify multiple values in a WHERE clause.

Syntax:

SELECT column_name(s) FROM table_name
WHERE column_name IN (value1,value2,value3,...)

Query:

SELECT * FROM EMPtbl1

WHERE EMPname IN (‘Batista', ‘William‘, ’Jakson’)