Remove duplicates

[@atchyuthkumarreddyanamola6571]

Exclusive

[@christiyaprincy1961]

Tq

[@shishankagrawal668]

2 se jada duplications hue to kese delete karenge

[@manukotabangarukota870]

Is there any alternate query sir

[@pramodnadageri7062]

there are couple of alternative solutions are there like 1.using self join. 2.adding a dummy column using "generated always as identity". 3. Deleting CTID if you are using Postgres or Oracle.

[@attaullahansari4621]

Yes