SQL IN Operator

The IN operator allows you to specifies multiple values in a WHERE clause.

Syntax:

SELECT *
FROM table_name
WHERE column_some_name IN (value_1,value_2,value_3,.....)

As you see, we have like this "Candidate" table.

Example:

select * from CANDIDATE where LastName in ('sohaliya','patel','sojitra')

Output: