DELETE SELECT

CREATE TABLE IF NOT EXISTS `Course` (`Id` varchar(80) ,`date` int(10) );

INSERT INTO `Course` (`Id`,`DATE`) VALUES ('Pommes', '101010'),('Poires', '101010'),('Pommes', '101012'),('Poires', '101012');

CREATE VIEW Doublon AS
SELECT Id AS Produit,Min(date) as date
FROM Course
GROUP BY ID;
   
DELETE FROM Course 
WHERE EXISTS (SELECT Doublon.Produit,Doublon.date FROM Doublon where Doublon.Produit=Course.Id and Doublon.date=Course.date);

DROP VIEW Doublon;

WHERE datecreation  ....

DELETE 
FROM matable 
WHERE datecreation = (SELECT MIN(datecreation ) FROM matable ) 

DELETE 
FROM matable 
WHERE ID IN (SELECT T.ID 
                         FROM ( SELECT ID, MIN(datecreation )
                                        FROM matable GROUP BY ID
                                      ) T
                        )  

DELETE FROM T_PROSPECT
WHERE  (CLI_NOM, CLI_PRENOM) = (SELECT PRP_NOM, PRP_PRENOM
                                FROM   T_CLIENT)

DELETE 
FROM matable 
WHERE (Id, datecreation) = (SELECT Id, MIN(datecreation ) FROM matable GROUP BY Id) 

DELETE t1 
FROM matable t1
INNER JOIN 
(
    SELECT Id, MIN(datecreation) as minDate FROM matable GROUP BY Id HAVING count(*) > 1
) T2 ON T1.Id = T2.Id AND t1.datecreation = t2.minDate;