无法在top中使用子查询 Top 语法

[   
    TOP (expression) [PERCENT]  
    [ WITH TIES ]  
]

表达 Is the numeric expression that specifies the number of rows to be returned. expression is implicitly converted to a float value if PERCENT is specified; otherwise, it is converted to bigint. 我们可以看到它不支持子查询 TOP 仅限 expression 编辑
我看到你改变了dbms的用途。
mysql不支持 TOP 但你可以用 LIMIT 获取限制行。
如果没有 PK 在你的table上，你可以试着用 dynamic SQL 决定在运行时要删除多少行。
架构（mysql v5.6）

CREATE TABLE tests(
test_name VARCHAR(50),
product_id int
);

INSERT INTO tests VALUES('WALLET_01',25);
INSERT INTO tests VALUES('WALLET_01',25);

SET @sql = NULL;
SET @Rn = NULL;
SELECT
   (COUNT(*)-1) 
INTO @Rn
FROM tests
WHERE test_name='WALLET_01' AND product_id=25;

SET @sql = CONCAT('DELETE FROM tests WHERE test_name=''WALLET_01'' AND product_id=25 limit ',@Rn);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

查询#1

SELECT * FROM tests;

| test_name | product_id |
| --------- | ---------- |
| WALLET_01 | 25         |

db fiddle视图