题目链接：点击打开链接
题目大意：略。
解题思路：解决方案(1) AC 不了，不过很奇怪，感觉逻辑没错，不知道错在哪里，希望路过的高手看看~
AC 代码
-- 解决方案(1) SELECT product_id, year first_year, quantity, price FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY product_id ORDER BY year) rnk FROM Sales) RS WHERE rnk = 1 -- 解决方案(2) select product_id,`year` first_year,quantity,price from Sales where (product_id,year) in (select product_id,min(year) from Sales group by product_id)
