DELETE FROM titles_test WHERE id NOT IN
(SELECT * FROM(SELECT MIN(id)
FROM titles_test
GROUP BY emp_no) AS a)