dublicated values of column in sql

in SQL / Another Example of Using COALESCE()

When creating a table, I mistakenly entered repeated values in a column. Please tell me how to remove those dublicated values of column, so they won't appear in the table anymore

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

04 Nov 2022

Hi Gohar!
Thanks for reaching out.

You can simply drop the table and create it again. Then, you can insert the data.

Hope this helps.
Best,
Tsvetelin

dublicated values of column in sql

Submit an answer

related questions