Essential Books

Simple IN clause

suggest change

To get records having any of the given ids 

select * 
from products
where id in (1,8,3)

The query above is equal to 

select * 
from products
where id = 1
   or id = 8
   or id = 3
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

IN clause:
*IN clause
*Simple IN clause
*Using IN clause with a subquery
Table Of Contents