Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subract count(*) from count(*) 1

Status
Not open for further replies.
pandatime

pandatime

Programmer
Joined
Jan 29, 2010
Messages
92
Location
AU
Hi,

is there a way to do this?

select count(*) from tab1
-
select count(*) from tab2

?

Thanks
 
Sort by date Sort by votes
This should do the trick:

Code: 
select (select count(*) from tab1)
-
(select count(*) from tab2) as [yourAnswer]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros
bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
792
bharons
bharons
BobThornton
  • Locked
  • Question Question
Drop a table based on the count of records in another table
Replies
13
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Avoid double counting
Replies
16
Views
2K
peac3
peac3
JD5241
  • Locked
  • Question Question
SQL Field - check for specific count of characters
Replies
2
Views
448
JD5241
JD5241

Part and Inventory Search

Sponsor

Back
Top