<pre lang="sql">WITH [CTE DUPLICATE] as (SELECT RN=ROW_NUMBER() OVER (ORDER BY name) FROM test ) delete from [CTE DUPLICATE] where RN<3
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)