[Solved] SQL query to count numbers [closed]

by


Try this

SELECT Video_id,COUNT(Video_id)
FROM tbl 
Group By Video_id

FIDDLE DEMO

O/P

VIDEO_ID COUNT(VIDEO_ID)
1        3
2        2
4        4

Take a look at these document

http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html

http://dev.mysql.com/doc/refman/5.1/en/group-by-extensions.html

0

solved SQL query to count numbers [closed]