Count how many rows have the same value [duplicate]

Question

How do I write an SQL query to count the total number of a specific num value in the num column of a table?

Assuming we have the following data.

NAME	NUM
SAM	1
BOB	1
JAKE	2
JOHN	4

Take the following query:

Click to copy

SELECT WHERE num = 1; 

This would return these two rows.

NAME	NUM
SAM	1
BOB	1

Answer 1

Try

Click to copy

SELECT NAME, count(*) as NUM FROM tbl GROUP BY NAME 

SQL FIDDLE

Answer 2

If you want to have the result for all values of NUM:

Click to copy

SELECT `NUM`, COUNT(*) AS `count`  FROM yourTable GROUP BY `NUM` 

Or just for one specific:

Click to copy

SELECT `NUM`, COUNT(*) AS `count`  FROM yourTable WHERE `NUM`=1