Function to clear duplicate values in the 'value' column of a table

The database contains a table with two columns: id – an auto-incrementing unique identifier, and value – a numeric field that may contain duplicate numbers. It is required to implement a function that deletes all duplicate records, leaving only one row for each unique value.

Example of the initial data:

id | value

1 | 1 2 | 2 3 | 2 4 | 3 5 | 3 6 | 3