sql语句,如何选出不同商品分别在1-5月份gmv的最大值及最大值所在的月份,根据商品分组
时间: 2024-02-17 17:04:51 浏览: 12
91]
[11,20,30,42,55,82,71,100,91,64]
[11,20,30,42,55,82,91,64,71,100]
[11,20,30,42,55,82,91你可以使用如下的SQL语句来选出不同商品分别在1-5月份GMV的最大值,64,100,71]
[11,20,30,42,55,82,91,71,64,100]
[及最大值所在的月份,根据商品分组:
```
SELECT
product_id,
MAX(gmv_11,20,30,42,55,82,91,71,100,64]
[11,20,30,42,1) AS max_gmv_1,
CASE MAX(gmv_1)
WHEN gmv_1 THEN 1
WHEN55,82,91,100,64,71]
[11,20,30,42,55,82,91,100, gmv_2 THEN 2
WHEN gmv_3 THEN 3
WHEN gmv_4 THEN 4
71,64]
[11,20,30,42,55,82,100,64,71,91]
[11,20 WHEN gmv_5 THEN 5
END AS max_month_1,
MAX(gmv_2) AS max_gmv_,30,42,55,82,100,64,91,71]
[11,20,30,42,55,822,
CASE MAX(gmv_2)
WHEN gmv_1 THEN 1
WHEN gmv_2 THEN 2,100,71,64,91]
[11,20,30,42,55,82,100,71,91,64
WHEN gmv_3 THEN 3
WHEN gmv_4 THEN 4
WHEN gmv_5 THEN ]
[11,20,30,42,55,82,100,91,64,71]
[11,20,30,5
END AS max_month_2,
MAX(gmv_3) AS max_gmv_3,
CASE MAX(gmv42,55,82,100,91,71,64]
[11,20,30,42,55,91,64,_3)
WHEN gmv_1 THEN 1
WHEN gmv_2 THEN 2
WHEN gmv_371,82,100]
[11,20,30,42,55,91,64,71,100,82]
[11 THEN 3
WHEN gmv_4 THEN 4
WHEN gmv_5 THEN 5
END AS max_month,20,30,42,55,91,64,82,71,100]
[11,20,30,42,55_3,
MAX(gmv_4) AS max_gmv_4,
CASE MAX(gmv_4)
WHEN gmv,91,64,82,100,71]
[11,20,30,42,55,91,64,100,71_1 THEN 1
WHEN gmv_2 THEN 2
WHEN gmv_3 THEN 3
WHEN g,82]
[11,20,30,42,55,91,64,100,82,71]
[11,20,mv_4 THEN 4
WHEN gmv_5 THEN 5
END AS max_month_4,
MAX(gmv30,42,55,91,71,64,82,100]
[11,20,30,42,55,91,_5) AS max_gmv_5,
CASE MAX(gmv_5)
WHEN gmv_1 THEN 1
71,64,100,82]
[11,20,30,42,55,91,71,82,64,100]
WHEN gmv_2 THEN 2
WHEN gmv_3 THEN 3
WHEN gmv_4 THEN 4
[11,20,30,42,55,91,71,82,100,64]
[11,20,30,42 WHEN gmv_5 THEN 5
END AS max_month_5
FROM
your_table
GROUP BY
product,55,91,71,100,64,82]
[11,20,30,42,55,91,71,100_id;
```
假设你的数据表中包含以下字段:
- product_id: 商品ID
- gmv_1:,82,64]
[11,20,30,42,55,91,82,64,71,100]
[11, 1月份的GMV
- gmv_2: 2月份的GMV
- gmv_3: 20,30,42,55,91,82,64,100,71]
[11,20,30,42,55,3月份的GMV
- gmv_4: 4月份的GMV
- gmv_5: 591,82,71,64,100]
[11,20,30,42,55,91,82,71,100,月份的GMV
这个SQL语句会根据商品ID进行分组,然后找出每个商品1-64]
[11,20,30,42,55,91,82,100,64,71]
[11,20,305月份GMV的最大值及其对应的月份。最终结果会返回每个商品ID以及对,42,55,91,82,100,71,64]
[11,20,30,42,55,91,100应的最大GMV值和最大GMV所在的月份。