擅长:python、mysql、java
<p>以下是sql代码、sqlachemy support all over()和PArition by语句以及cte的使用,只需遵循sqlachemy文档:</p>
<pre><code>;WITH cte AS (
SELECT
*
, rank() OVER (PARTITION BY p.client_id , p.product_id ORDER BY p.purchased_at ASC) rnk
FROM
product AS p
)
SELECT cte.client_id
, cte.product_id
, cte.purchased_at
FROM cte
WHERE cte.rnk = 1
</code></pre>