Summary count

Hi,

Is was wondering if EEs can show me the most efficient way to do this. I have a table that has a column "Activity". The value contains the following:
Call
Email
Meeting
Deadline
Lunch

I want to see if there is a way to show the result with the count with each activity, such as

Call (10), Email (1), Meeting (5)......

thanks
mcrmgAsked:
Who is Participating?
 
Jan LouwerensSoftware EngineerCommented:
SELECT Activity, COUNT(*) FROM <table_name>
GROUP BY Activity

Open in new window

0
 
mcrmgAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.