SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DROP TABLE IF EXISTS #SampleData;

CREATE TABLE #SampleData
(
IntegerValue INTEGER,
);

INSERT INTO #SampleData VALUES
(1),(1),(2),(3),(3),(4);

SELECT *
FROM #SampleData

IntegerValue

1

1

2

3

3

4

WITH cte_Duplicates AS
(
SELECT  ROW_NUMBER() OVER (PARTITION BY IntegerValue ORDER BY IntegerValue) AS Rnk
FROM    #SampleData
)
DELETE FROM cte_Duplicates WHERE Rnk > 1
2 rows affected

SELECT *
FROM #SampleData

IntegerValue

1

2

3

4