Hello
I need your help,
I have a table in which some records have been duplicated .based on one field ( ex. Id ) I need to change the duplicated Id ( ex . add -1 at the end of it )
how can I do it in a query? how can ask to find the duplicated records and change the id ?
thank you in advance
I need your help,
I have a table in which some records have been duplicated .based on one field ( ex. Id ) I need to change the duplicated Id ( ex . add -1 at the end of it )
how can I do it in a query? how can ask to find the duplicated records and change the id ?
thank you in advance