How to delete all duplicate records from sql

Question

i have table in sql and I want to remove duplicate records but remove all duplicate records

First name	last name
a	b
a	b
a	c

question from:https://stackoverflow.com/questions/65872042/how-to-delete-all-duplicate-records-from-sql

Answer 1

You can use group by:

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