Oracle SQL Query IN

Question

I have following query, that's not working.

select * from table where id in (
   1,2, (select id from another_table)
)

How i can rewrite it?

piet.t · Accepted Answer · 2014-03-11 14:42:15Z

2

How about

select * from table 
where id in (1,2)
   or id in (select id from another_table)

Take care and use parentheses when adding additional WHERE-conditions using and!!!

answered Mar 11, 2014 at 14:42

piet.t

11.9k21 gold badges45 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

phlogratos · Accepted Answer · 2014-03-11 14:42:50Z

1

select * 
from table 
where id in (1,2) OR id in(
   select id from another_table
)

answered Mar 11, 2014 at 14:42

phlogratos

14k1 gold badge35 silver badges38 bronze badges

KrazzyNefarious · Accepted Answer · 2014-03-11 14:42:04Z

0

select * from table where id in (
select 1 as id from dual
union all
select 2 as id from dual
union all
select id from another_table
)

answered Mar 11, 2014 at 14:42

KrazzyNefarious

3,2303 gold badges22 silver badges32 bronze badges

Mehmet Ince · Accepted Answer · 2014-03-11 15:03:01Z

0

select * from table where id in (
   select 1 from dual
     union all
   select 2 from dual
     union all
   select id from another_table);

I'm using union because this is faster than using an OR clause which also can be used.

Mehmet Ince

4,21914 gold badges48 silver badges65 bronze badges

answered Mar 11, 2014 at 14:43

user3406675

1589 bronze badges