Delete the duplicated record in the table

Updated at : 11/08/2022

379 Views

Dhamo Daran
6 Posts

Consider the table as below

Number  Value1  Date            Value2
40325   1       21/01/11 18.10  2
65485   3       22/01/11 16.47  2
40325   9       25/01/11 19.00  0
70912   8       27/01/11 16.43  2

Delete the old record if it is duplicated.

sql

Published By : Dhamo Daran

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

Comments