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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.