问使用CTE删除Greenplum中的真实重复项

EN

ERROR:  syntax error at or near "DELETE"
LINE 60: DELETE FROM CTE where row_num=2;
         ^
********** Error **********

ERROR: syntax error at or near "DELETE"
SQL state: 42601
Character: 1125

WITH CTE AS (select  ROW_NUMBER() OVER( PARTITION BY column1,
column2,
column3
ORDER BY column2 DESC, column3 asc ) AS row_num,
column1,
column2,
column3
column4
load_feed_num
from MT_TABLE_NAME
where column2='some value here')
DELETE FROM CTE where row_num=2;