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>

B12343C

Nitya Raut

Updated on: 2019-12-18T10:05:14+05:30

187 Views

Get certified by completing the course