How to count rows that have the same values in two columns (SQL)?

Question

I am sure there must be a relatively straightforward way to do this, but it is escaping me at the moment. Suppose I have a SQL table like this:

+-----+-----+-----+-----+-----+ |  A  |  B  |  C  |  D  |  E  | +=====+=====+=====+=====+=====+ |  1  |  2  |  3  | foo | bar | << 1,2 +-----+-----+-----+-----+-----+ |  1  |  3  |  3  | biz | bar | << 1,3 +-----+-----+-----+-----+-----+ |  1  |  2  |  4  |  x  |  y  | << 1,2 +-----+-----+-----+-----+-----+ |  1  |  2  |  5  | foo | bar | << 1,2 +-----+-----+-----+-----+-----+ |  4  |  2  |  3  | foo | bar | << 4,2 +-----+-----+-----+-----+-----+ |  1  |  3  |  3  | foo | bar | << 1,3 +-----+-----+-----+-----+-----+ 

Now, I want to know how many times each combination of values for columns A and B appear, regardless of the other columns. So, in this example, I want an output something like this:

+-----+-----+-----+ |  A  |  B  |count| +=====+=====+=====+ |  1  |  2  |  3  | +-----+-----+-----+ |  1  |  3  |  2  | +-----+-----+-----+ |  4  |  2  |  1  | +-----+-----+-----+ 

What would be the SQL to determine that? I feel like this must not be a very uncommon thing to want to do.

Thanks!

Answer 1

SELECT A,B,COUNT(*) FROM the-table GROUP BY A,B 

Answer 2

TRY:

SELECT     A, B , COUNT(*)     FROM YourTable     GROUP BY A, B