Link to home
Start Free TrialLog in
Avatar of dbasaurus
dbasaurus

asked on

MySQL Count Query

I have a MySQL table that contains an employee number, and a column called action. For example:

employee_id   action
1                     change address
1                     change address
1                     change address
1                     change address
1                     transfer
1                     vacation
1                     change address
1                     change address
2                     change address
2                     change address
2                     transfer
2                    vacation
4                     change address
4                     change address
4                     change address
3                     change address
1                     transfer
1                     vacation

What I want to do is create a result set that has how many employee_ids have changed there address more than once.
ASKER CERTIFIED SOLUTION
Avatar of jimmycdinata
jimmycdinata
Flag of Indonesia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial