How to delete duplicate data in MySQL on new version?
22:34 24 Sep 2023

I have the following table:

SchoolId    StudentName 
101        Majid Bhuiyan
101        Majid Bhuiyan
102        Arif
103        Tamim Rahman
104        Sourov Doggesh

I need MySQL code that deletes only one of the duplicate rows:

SchoolId  StudentName
101       Majid Bhuiyan

This row appears twice in the table. How can I remove the duplicate? Please help.

mysql