DELETE t1 FROM students t1
INNER JOIN students t2
WHERE
t1.UserID > t2.UserID AND
t1.Email = t2.Email;
Reference: https://www.mysqltutorial.org/mysql-delete-duplicate-rows/
Delete Duplicate rows in SQL Table
Related Posts
Hello world!
Hello, my name is Ewala. I come from the planet Alawe, in the galaxy Ewala, in the universe Alawe. But ...
COVID-19 Govt. of India Guidelines during LockDown between 25th March 2020 to 14th April 2020
The Below Information is taken from the Indian Government. Please use the link for updated Information: https://www.mygov.in/covid-19/. COVID 19 #IndiaFightsCorona ...
Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing! ...