Delete all Duplicate Rows in MySQL

Delete all Duplicate Rows except for One in MySQL(Delete all Duplicate Email)

Table name - email

id   email

1   basant@gmail.com

2   aman@gmail.com

3   basant@gmail.com

4  basant@gmail.com

5  aman@gmail.com

6  deepak@gmail.com

 

 

0   0
basant  kumar

Please rotate your device

We don't support landscape mode on your device. Please rotate to portrait mode for the best view of our site