SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to sum two queries up

Mark1970Jul 8 2010 — edited Jul 8 2010

If I perform this query

select count(*) total
from table1
UNION
select count(*) total
from table2

I get something like this

TOTAL
--------
100
150

What I'd like to get is an unique row

TOTAL
--------
250

Any advice?
Thanks!

Edited by: Mark1970 on 8-lug-2010 5.29

This post has been answered by Sven W. on Jul 8 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2010

Added on Jul 8 2010

6 comments

16,939 views