Delete duplicate rows
I need to delete one of the duplicate rows from the table as follows
ID(PK) Firstname Lastname
001 ANDRE BAS
002 ANDRE BAS
003 CHARLIE DAVID
004 CHARLIE DAVID
005 RUSH WELL
006 RUSH WELL
Thanks
I need to delete one of the duplicate rows from the table as follows
ID(PK) Firstname Lastname
001 ANDRE BAS
002 ANDRE BAS
003 CHARLIE DAVID
004 CHARLIE DAVID
005 RUSH WELL
006 RUSH WELL
Thanks