[Solved] How to delete all duplicate records from sql

You can use group by:

select first_name, last_name
from t
group by first_name, last_name
having count(*) = 1;