SQL SELECT IN

Last Updated : 27 Jan 2026

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

It is used in SELECT, INSERT, UPDATE or DELETE statement.

Advantage of SQL SELECT IN

It minimizes the use of SQL OR operator.

Let's see the syntax for SQL IN:

Take an example with character values.

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

Let's take another example with numeric values.

SELECT *
FROM marks
WHERE roll_no IN (001, 023, 024);

Next TopicSQL Select From Multiple Tables

<<prev next>>

We deliver comprehensive tutorials, interview question-answers, MCQs, study materials on leading programming languages and web technologies like Data Science, MEAN/MERN full stack development, Python, Java, C++, C, HTML, React, Angular, PHP and much more to support your learning and career growth.