sql select where value in code example

Example 1: where id is in list sql

select * from table where id in (id1,id2.........long list)

Example 2: what is in condition in sql

IN condition allows you to easily test
if an expression matches any value in a list of values.
It is for reducing  multiple OR
conditions in a SELECT, INSERT,
UPDATE, or DELETE statement.