djeanthi
asked on
To find the count of rows returned by minus in oralce
hi,
select * from a
minus
select * from b
here how to find the no. of rows returned by the above query.
thanks in advance
Regards
S.Djeanthi
select * from a
minus
select * from b
here how to find the no. of rows returned by the above query.
thanks in advance
Regards
S.Djeanthi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
e.g.
select count(*)
from a
where not exists (select * from b
where a.primary key = b.primary key)