• [^] # Re: pfiou

    Posté par . En réponse au message SQL : Requête d'update.. Évalué à 2.

    delete from my_table
    where (col1,col2,col3) in
    ( select col1,col2,col3 from my_table group by col1,col2,col3 having count(*)>1 )
    and id not in ( select min(id) from my_table group by col1,col2,col3 having count(*)>1 )