擅长:python、mysql、java
<p>我还没有测试过,但这可能会起作用:</p>
<pre><code>DELETE FROM TableName
WHERE author, body, points NOT IN (SELECT author, body, MAX(points) as points
FROM TableName
GROUP BY author, body)
</code></pre>
<p>首先以SELECT查询的形式运行它,看看它是否能保持您想要的结果。在</p>