Delete duplicate alphanumeric entries from column data in SQL

SQLSQLiteDatabase

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
raja
Updated on 18-Dec-2019 10:05:14

Advertisements