sql

 1. hapus data duplicate lebih dari 1  SQL 2005

with CTE as (

SELECT BARA, KODE,

RN = ROW_NUMBER()OVER(PARTITION BY BARA, KODE ORDER BY BARA)

FROM tes

)

DELETE FROM CTE WHERE RN > 1

2. Hapus data duplicate lebih dari 1 sql 2000

supplier tidak bisa update

CREATE TABLE temp_tes (

    bara varchar(255),

    kode varchar(255),

);

INSERT INTO temp_tes ( bara, kode  ) select max(bara), max(kode) from tsupp GROUP BY bara

select * from temp_tes where bara = '6006304'

select * from tsupp where bara = '6006304'

INSERT INTO tsupp ( bara, kode ) select max(bara), max(kode) from temp_tes GROUP BY bara

select * from tsupp

TRUNCATE TABLE tsupp;

TRUNCATE TABLE temp_tes;