Skip to Main Content
Forums

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 compare record count of two tables?

RamanJan 9 2009 — edited Jan 9 2009
Hi,

i am in need of simple sql script where i can compare two table record count.

i have something like below:

(select count(*) from table1) minus (select count(*) from table2)

now the problem is if the table1 count greater then table2 count the output is fine.

If the table2 record count is more then i am getting zero as the output.

how can i get the difference in two tables record count?

Thanks a lot in advance.

--Raman.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2009
Added on Jan 9 2009
6 comments
13,200 views