MySQL Query for substring and count

Question

I have done quite a bit of research and found some useful sql examples but can't seem to get exactly what I want.

1. Employee Table
ID, EmployeeName

2. Absence Table
ID, Employee_ID, Reason

I need a report with distinct first letters of the employee's name and another column with a count of how many times that certain category was absent!

Nope, by category I meant the count of the items in the first column. sorry — user908156
– user908156, Commented Aug 24, 2011 at 17:02

Daniel Pereira · Accepted Answer · 2011-08-24 17:09:01Z

2

Select LEFT(a.EmployeeName, <number of chars you want>), COUNT(b.EmployeeId) 
FROM Employee a, Absence b 
WHERE a.ID = b.Employee_ID GROUP BY a.ID

answered Aug 24, 2011 at 17:09

Daniel Pereira

1,78312 silver badges10 bronze badges

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

Comments

Andrej · Accepted Answer · 2011-08-24 17:09:07Z

1

Try this query

select substr(EmployeeName, 1, 1) as emp_name, count(*) from
Employee e inner join Absence a on e.ID=a.Employee_ID
group by emp_name

answered Aug 24, 2011 at 17:09

Andrej

7,5041 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

MySQL Query for substring and count

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related