QUESTION POSED ON: 19 June 2008
Can you please tell me the advantage of using IN clause where the same can be
done using the OR clause? For example:
select * from a
where a.id in ('1','2','3')
or
select * from a
where a.id='1'
or a.id='2'
or a.id='3'
Which one is advisable?
|