6 select statements with one id in where clause code example Example: where id is in list sql select * from table where id in (id1,id2.........long list)