Join two counts in sql query

Question

Is it possible to have the sum of next two queries in one query?

select COUNT(1) 
from BinaryAssets.BinaryAssetsTags
where TagId = 1731

select COUNT(1) 
from Planning.ScheduleTag
where TagId = 1731

Result from first query is 3 for example, from the second 2. I want one query that gives me back 5.

Lieven Cardoen · Accepted Answer · 2011-01-10 09:04:26Z

6

SELECT 
(select COUNT(1) from BinaryAssets.BinaryAssetsTags where TagId = 1731) 
+ 
(select COUNT(1) from Planning.ScheduleTag where TagId = 1731) 
AS total_sum

edited Jan 10, 2011 at 9:04

Lieven Cardoen

26.1k55 gold badges159 silver badges253 bronze badges

answered Jan 10, 2011 at 9:01

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Srinivas Reddy Thatiparthy · Accepted Answer · 2011-01-10 09:03:29Z

2

You can follow this syntax ,

select (select Count(1) from a)+(select Count(1) from b) as 'Total Count'

answered Jan 10, 2011 at 9:03

Srinivas Reddy Thatiparthy

11.2k4 gold badges48 silver badges68 bronze badges

Collectives™ on Stack Overflow

Join two counts in sql query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related