擅长:python、mysql、java
<p>您可以获得每个tdate的买卖对数,并更新这些行。在</p>
<pre><code>MERGE INTO tablename dst
USING (select t.*,count(*) over(partition by tDate,Product,Price,Quantity,rn) as cnt
from (select t.*,row_number() over(partition by tDate,Product,Price,Quantity,buysell order by id) as rn
from tablename t) t
) src
ON (src.id = dst.id AND src.cnt=2)
WHEN MATCHED THEN
UPDATE SET Status = 'Matched';
</code></pre>
<p>运行此查询以查看行号是如何分配给买卖的。在</p>
^{pr2}$