Sum two counts in sql

Question

I'm having a question, I am building up a query.

select top 10 usr.firstname, usr.lastname, count(doc.modifiedBy) as modified_items,
       count(doc.createdDate) as created_items 
from document doc
where doc.active = 't' 
group by usr.firstname, usr.lastname
order by doc.modified_items desc

But I want to sum two counts that are in select so something like this.

select top 10 usr.firstname, usr.lastname, sum(count(doc.modifiedBy), count(doc.createdDate))

You mean like count(doc.modifiedBy) + count(doc.createdDate)? — shree.pat18
– shree.pat18, Commented Nov 26, 2015 at 10:41
Note that if you add them using + then records with both a modified date and a created date will be counted twice. This may or may not be what you want. — Andy Nichols
– Andy Nichols, Commented Nov 26, 2015 at 10:57

Matt · Accepted Answer · 2015-11-26 10:46:47Z

4

Simple just add + them.

SELECT TOP 10 usr.firstname, usr.lastname, count(doc.modifiedBy) AS modified_items, count(doc.createdDate) AS created_items, (count(doc.modifiedBy)) + (count(doc.createdDate)) AS summed_items
FROM document doc
WHERE doc.active = 't' 
GROUP BY usr.firstname, usr.lastname
ORDER BY doc.modified_items DESC

answered Nov 26, 2015 at 10:46

Matt

15.1k28 gold badges109 silver badges161 bronze badges

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

Collectives™ on Stack Overflow

Sum two counts in sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related