Using SQL SELECT and COUNT together

Question

I have a table that has the following fields:

Name | Category | Description

I want to select all categories and display them like:

Category | Category Count

So how would I do a

SELECT Category FROM MyTable 
UNION
SELECT COUNT(Category)

but have the count show the specific count for that row?

I was going to post, but this one is just too basic. Boogada, research the GROUP BY clause, it should give you what you need. — Bernard Dy
– Bernard Dy, Commented Mar 3, 2011 at 2:48

offex · Accepted Answer · 2011-03-03 02:48:01Z

7

Try this:

SELECT Category, COUNT(Category) FROM MyTable GROUP BY Category;

answered Mar 3, 2011 at 2:48

offex

1,8855 gold badges17 silver badges27 bronze badges

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

Comments

Arunsiva05 · Accepted Answer · 2011-03-03 04:16:36Z

0

Here is other example without group by function

Select category, count(category) over () from MyTable

answered Mar 3, 2011 at 4:16

Arunsiva05

1