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 -> Re: 2 select(count(*)) in a query

Re: 2 select(count(*)) in a query

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 21 Sep 2001 07:41:02 -0700
Message-ID: <a6d06107.0109210641.29250850@posting.google.com> 





> 

> I've got 2 tables and I ask to myself if we can count total elements of

> the 2 tables in one query

> 

> Ex : select count(*) from A + select count(*) from B.





select count(*) from a union all select count(*) from b



hth


Rene
Received on Fri Sep 21 2001 - 09:41:02 CDT












Original text of this message













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