SQL每日一题(20211116)
SQL每日一题(20220406)
WITH t1 AS(
SELECT *, row_number() over (PARTITION by 物品 ORDER BY 购买日期 DESC) rnk
FROM t0929)
SELECT 物品,
IFNULL(sum(IF(rnk=1,单价,0)),0) 最新,
IFNULL(sum(IF(rnk=2,单价,0)),0) 上次,
IFNULL(sum(IF(rnk=3,单价,0)),0) 上上次
FROM t1
GROUP BY 物品