how to return count using mysql query?

Question

i have a mysql table which contains

id,(primary key)

user_id,

**number**,

date

columns.I want a query which select count number for same date and same user_id.

for example,date column have 3 entries of 09/07/2014,then i want a query which return count 3.

my where condition contains only user_id

SELECT number,date FROM play_history WHERE  user_id =49

Thanks

juergen d · Accepted Answer · 2014-07-09 10:54:09Z

1

select `date`, count(`number`) as num_count
from play_history 
where user_id = 49
group by `date`

answered Jul 9, 2014 at 10:54

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Answer 1