Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> AND or UNION

AND or UNION

From: Wong Chung Yin <cscywong_at_ug.cs.ust.hk>
Date: 1997/02/13
Message-ID: <5du2ti$rel@ustsu10.ust.hk>#1/1

Hi,

        Which one is more efficient?

  1. select * from empdemo where empdemo = 0 and empdemo = 1;
  2. select * from empdemo where empdemo = 0 union select * from empdemo where empdemo = 1;
Received on Thu Feb 13 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US