擅长:python、mysql、java
<p>您可能会发现“EXISTS”条件很有用:(未经测试的查询提供一个想法)</p>
<pre><code>DELETE
FROM tenant_counter
WHERE EXISTS
(SELECT rn.date, MAX(rn.sayacdeger) AS maxvalue
FROM tenant_counter rn
WHERE tenant_counter.date = rn.date
AND tenant_counter.sayacdeger = rn.maxvalue
AND rn.date IS NULL
GROUP BY rn.date)
</code></pre>