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

@asprin output is perfect what if i want the output as :distinct_user and no_of_resumes — user3710364
– user3710364, Commented Jun 17, 2014 at 8:57

Vignesh Kumar A · Accepted Answer · 2014-06-17 08:51:01Z

1

Try this

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

answered Jun 17, 2014 at 8:51

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

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

Comments

Hasan Fathi · Accepted Answer · 2016-01-04 13:49:36Z

0

This Query :

SELECT distinct user, COUNT(attachresume) FROM table_name GROUP BY user

Hasan Fathi

6,1864 gold badges49 silver badges67 bronze badges

answered Jun 17, 2014 at 9:28

user3747721

161 bronze badge