Delete duplicate alphanumeric entries from column data in SQL

You can opt for using regular expressions to remove the duplicate numbers from column c or any other intended column.

Example

SELECT REPLACE_REGEXPR ('([A-Za-z0-9])\1+' in 'BB11222343CC'    WITH '\1'    OCCURRENCE ALL) FROM <table_Name>

Output

B12343C