TSQL Query count with multiple columns

Question

I have a table that is structured like so:

Account, Tag
------------
123, dog
123, owl
456, pig
456, goat
678, dog
789, owl

I need to create a statement that will return the following data:

Tag name with the total number of account it's on:

Dog 2
owl 2
pig 1
goat 1

Raphaël Althaus · Accepted Answer · 2013-11-12 18:21:15Z

3

select Tag, count(*)
from table
group by Tag

answered Nov 12, 2013 at 18:21

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

2 Comments

SBB Over a year ago

How would I include another column in there as well? I have one more called total clicks so I need to add up all the clicks that each keyword has in total

Aaron Bertrand Over a year ago

@SBB add , SUM(clicks) to the select list

Collectives™ on Stack Overflow

TSQL Query count with multiple columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related