Last answered:

04 Nov 2022

Posted on:

30 Oct 2022

0

dublicated values of column in sql

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)
Instructor
Posted on:

04 Nov 2022

1

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

Submit an answer