Question

oracle 查询语句 id='1' 和id='2'的都查询出来怎么写?

Answer 1

很多种写法；

1. select * from tab where id='1' or id = '2'
2. select * from tab where id in ('1','2')
3. select * from tab where id='1'
union
select * from tab where id = '2'

Answer 2

select * from tableName where id='1' or id='2'
select * from tableName where id in('1','2')
如果ID是int类型完全可以将单引号去掉
select * from tableName where id=1 or id=2
select * from tableName where id in (1,2)

Answer 3

selecet * from table t where t.id in ('1', '2');
如果你有3，4，5 等 ，像1和2一样的格式往括号里面加就好了

Answer 4

id='1' or id='2'
id in ('1','2')

Answer 5

where id='1' or id='2'