row_number涓嶈兘鐩存帴鐢ㄤ簬鍒犻櫎閲嶅璁板綍锛屼絾鍙互閰嶅悎浣跨敤鍏朵粬鏂规硶瀹炵幇鍒犻櫎閲嶅璁板綍鐨勫姛鑳姐€?/p>

涓€绉嶅父瑙佺殑鏂规硶鏄娇鐢╮ow_number()鍑芥暟鐢熸垚琛屽彿锛岀劧鍚庝娇鐢ㄨ繖涓鍙锋潵鏍囪閲嶅璁板綍锛屾渶鍚庢牴鎹繖涓爣璁版潵鍒犻櫎閲嶅璁板綍銆傚叿浣撴楠ゅ涓嬶細

1. 浣跨敤row_number()鍑芥暟鐢熸垚琛屽彿锛屾寜鐓ч渶瑕佸幓閲嶇殑瀛楁杩涜鍒嗙粍鎺掑簭銆?/li>
2. 浣跨敤瀛愭煡璇㈠皢鐢熸垚鐨勮鍙蜂綔涓烘柊鐨勫瓧娈碉紝缁欓噸澶嶈褰曞仛鏍囪銆?/li>
3. 浣跨敤DELETE璇彞鍒犻櫎鏍囪涓洪噸澶嶇殑璁板綍銆?/li>

绀轰緥浠ｇ爜濡備笅锛?/p>

WITH cte AS (
  SELECT 
    *,
    ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY column1) AS row_num
  FROM your_table
)
DELETE FROM cte WHERE row_num > 1;

鍦ㄤ笂闈㈢殑浠ｇ爜涓紝鍋囪瑕佸垹闄ら噸澶嶈褰曪紝鏍规嵁column1鍜宑olumn2瀛楁杩涜鍘婚噸銆備娇鐢╮ow_number()鍑芥暟鎸夌収杩欎袱涓瓧娈佃繘琛屽垎缁勬帓搴忥紝鐢熸垚琛屽彿锛岀劧鍚庡皢鐢熸垚鐨勮鍙蜂綔涓烘柊鐨勫瓧娈祌ow_num锛屾渶鍚庢牴鎹畆ow_num澶т簬1鐨勮褰曞垹闄ら噸澶嶈褰曘€?/p>