All Forums Database
Niesh20us 78 posts Joined 06/13
08 Oct 2015
IN Clause

Hi Experts,
Can anyone tell me the difference between below 2 queries . I know result will be same for both the queries but which one will better performance and why ?
delete from tableA where columnA=123;
delete from tableA where columnA in (123);

oshun 43 posts Joined 07/10
08 Oct 2015

There is no difference.

visit my private blog at

You must sign in to leave a comment.