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
Published on 15-Dec-2017 17:41:57
Advertisements