Home >> SQL >> IN clause in SQL

IN clause in SQL

The IN clause allows multiple values in a WHERE clause.

It is work like multiple OR conditions.

Syntax

SELECT * FROM tablename WHERE name IN (value1,value2,value3,...)

Post Your Comment

Next Questions
Order By
Group By
Distinct keyword
Sorting
Between
Having
Union
Union all
Exits
Not Exits
Any
All
Max
Min
Avg
Count
Sum

Copyright ©2022 coderraj.com. All Rights Reserved.