Remove duplicates from table

PHOTO EMBED

Sat Aug 21 2021 14:41:38 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #sql

CREATE OR REPLACE TABLE talentcards.users
AS
SELECT DISTINCT * FROM talentcards.users
content_copyCOPY

It drops the old table. All fields will be nullable after this. It only works when the entire row has the exact same values.