How to remove duplicate rows in CRDB

I have populated some of the rows twice into the table, and I need to remove the duplicate rows,

What would be the best wat to remove duplicate rows?

maybe this can help: sql: How to remove duplicate rows

You can also do CREATE TABLE table_copy(...) AS SELECT UNIQUE col1, col2, col3, ... FROM table_orig.