Buzovskiy/delete_duplicates.sql

## delete_duplicates.sql
CREATE TEMPORARY TABLE `t_temp`
as  (
   SELECT min(id) as id
   FROM `table`
   GROUP BY name, surname
);

DELETE from `table`
WHERE `table`.id not in (
   SELECT id FROM t_temp
);
	CREATE TEMPORARY TABLE `t_temp`
	as (
	SELECT min(id) as id
	FROM `table`
	GROUP BY name, surname
	);

	DELETE from `table`
	WHERE `table`.id not in (
	SELECT id FROM t_temp
	);