0

I have a dataset whereby duplicates can be found. I find the duplicates via matching matchID and the player_name column. However, after finding this information, how do I delete this group of duplicates from the dataset?

Image of the Duplicates

SELECT
    *
FROM
    project.worldcup_players;

SELECT
    MatchID, Player_Name, COUNT(*) AS NumDuplicates
FROM
    project.worldcup_players
GROUP BY
    MatchID, Player_Name
HAVING
    NumDuplicates > 1; 
marc_s
  • 704,970
  • 168
  • 1,303
  • 1,425
  • can you provide the field names and types for both the input and output table, as well as some sample rows? – lemon Apr 02 '22 at 01:32

0 Answers0