how to delete duplicate rows from table
WITH T1 AS (Select *, ROW_NUMBER() OVER (PARTITION BY id Order By id) AS rowid From test)
along with your userid / name. ThanQ
Site Map
