SQL SELECT IN

SQL SELECT IN is an operator used in a SQL query to help reduce the need to use multiple SQL \”OR\” conditions.

Syntax :

Expression IN (value 1, value 2 ... value n);
  

Example :

SELECT *
FROM students
WHERE students_name IN ( Amit , Raghav, Rajeev)