How do you find the difference between the number of rows in two different tables?
Requires Free Membership to View
The only thing that comes to mind is:
select (select count(*) from table1)
-(select count(*) from table2) as diff
If there was something more complicated about the question, then I'm sorry, I didn't catch it.
This was first published in May 2007
Join the conversationComment
Share
Comments
Results
Contribute to the conversation