Saturday, August 18, 2012

How to get counts of first table ,second table and both tables in a join in single query?


select
(select count(*) from a),
(select count(*) from b),
(select count(*) from a,b)
from dual

No comments:

Post a Comment