Union query
Posted by:
swe ishu
Date: August 06, 2011 04:51AM
I have written a query like,
Select count(*) from table where date='2011-08-06'
union
select count(*) from table where date='2011-08-07'
The output is,
21
25
Suppose if both queries returns same value, then i am getting only 1 row. But i need both rows to be displayed. Is it possible? if not is there any other way to do this?
Thank you
Swetha
Subject
Written By
Posted
Union query
August 06, 2011 04:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.