MySQL is not allowed to delete record with selecting action. So the point of this problem is rebuilding a new chart for next step of deleting.

DELETE FROM titles_test
WHERE id NOT IN (
    SELECT * FROM(
    SELECT MIN(id)
    FROM titles_test
    GROUP BY emp_no
) as A
)