I am having a problem with my SQL query?

Databases
1

hELLO THERE
When I run: SELECT DISTINCT groupLetter FROM well_tbl
I get:
|groupLetter |
|group A |
|group B |

When I run: SELECT COUNT() FROM well_tbl
I get:
|COUNT()|
|78 |

I will like to count all records pertaining to their respective groupLetters, so I ran:
SELECT COUNT(*) FROM well_tbl WHERE groupLetter = “(SELECT DISTINCT groupLetter FROM well_tbl)”

and I got:
|COUNT(*)|
|78 |

What am I missing?

I am using PHP/MySQL

2

GROUP BY is your friend.

SELECT groupLetter
     , COUNT(*) AS letterCount
  FROM well_tbl
 GROUP BY groupLetter
3

@DaveMaxwell, thanks so much, it worked. Please any MySQL references in pdf you can recommend to me, given that I am mostly offline.

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.