“AND ..和... and”和“and（and .. and）”之间的区别

I have two statement sql for oracle 11gr2

我有两个用于oracle 11gr2的语句sql

sql1:

Select * from tableA inpt, tableB ptbs
where inpt.z='A'
AND (inpt.pid    = ptbs.pid
     AND  inpt.instcd = ptbs.instcd);

sql2:

Select * from tableA inpt, tableB ptbs
where inpt.z='A'
AND inpt.pid    = ptbs.pid
     AND  inpt.instcd = ptbs.instcd

Sql1 is faster than sql2?

Sql1比sql2快吗?

The writing ... and ... and ... and ... Slowly write and (... and ... and (... and ... and ...))?

写作......和......以及... ......慢慢地写和(......和......以及......(......和......))?

Similar to "or"?

类似于“或”?

2 个解决方案

There is no difference here.

这里没有区别。

 where inpt.z='A'
    AND (inpt.pid    = ptbs.pid
         AND  inpt.instcd = ptbs.instcd);

where inpt.z='A'
AND inpt.pid    = ptbs.pid
     AND  inpt.instcd = ptbs.instcd

where inpt.pid    = ptbs.pid
     AND  inpt.instcd = ptbs.instcd and inpt.z='A'

All is the same.

一切都是一样的。