Find and remove duplicate rows - WITH CTE

with CTE as (

select

 col1
      ,col2
      ,col3
      ,col4
      ,col5
      ,col6

  ,RN = ROW_NUMBER()OVER(PARTITION BY  col1 ,col2  ORDER BY col1,col2)

  FROM [database].[schema].[table]
)
--select * from cte where RN >1

delete from cte where RN >1

Find only data between quotes (')

 select


SUBSTRING(RIGHT(inputtext,LEN(inputtext)-CHARINDEX('''',inputtext))
,0, CHARINDEX('''', RIGHT(inputtext,LEN(outputtext)-CHARINDEX('''',inputtext)) ) )

 from table