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