SQL Row Counting

ve

My head is fried and I can't seem to think of a way to achieve the following in a single query.

I have the following tableA

---

| id | value |

---

| 1 | A |
| 2 | A |
| 3 | B |
| 4 | A |
| 5 | B |
| 6 | A |
| 7 | B |

---

How can I use SQL count to return:
A: 4
B: 3

Where the number is the frequency of occurance for a particular value. I have been looking at the count function and examples thereof, and my head keeps saying "Blah!".

Appreciate any pointers you can offer.

NeverSayDie

This should get you in the right direction;
http://www.w3schools.com/sql/sql_groupby.asp

ve

/slaps own head :rolleyes:

Group By, but of course...

select count(value) from TableA group by value

Oh my head is not working today.

Cheers

Tom Dunne

ve wrote: »

/slaps own head :rolleyes:

Group By, but of course...

select count(value) from TableA group by value

Oh my head is not working today.

Cheers

That will only return the following:

4
3

You need to add in the VALUE column:

SELECT VALUE, count(value) from TableA group by value

/pedantic

ve

LOL, don't worry. I was just trying to keep the focus of my problem as concise as possible. I have it all working in place now.

My table wasn't actually called TableA, or the column called value. It was merely created to illustrate the problem at hand. Muhahahahaha. /runs

Thanks for all the help folks.