CODEWITHSUNDEEP
sqlsql-server
Wojciech Szabowicz
Wojciech Szabowicz

Reputation: 4198

Sum two counts in sql

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))

Upvotes: 1

Views: 305

Answers (1)

Matt
Matt

Reputation: 15071

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

Upvotes: 4

Related Questions