vendredi 8 mai 2015

How to delete all the records except the one with the latest date and based on some where condition

I have a table with 20 records. Now I want to delete records with column name as Action "system sent reminder notice to A"(15 records with same message) apart from the one with the latest date (I cant specify the date on or before, as I wanted this to be in general).

Aucun commentaire:

Enregistrer un commentaire