Select count from mysql

Question

i have a table containing fields as id user name .... attachresume.

My query:

to count the number of resume attached by distinct user, i have tried sub query but am not getting the required output

Answer 1

Try this

SELECT ID,UserName,Count(attachresume) AS [No Of Resume]
From Table1
Group By ID,UserName