是薛同学

分类

/ 注册

全部文章（共15篇）

题解 | #获得积分最多的人(二)#

SELECT id,NAME,grade FROM (SELECT id ,NAME ,grade ,RANK() OVER(ORDER BY grade DESC) AS rk FROM user AS a LEFT JOIN (SELECT DISTINCT ...

2024-01-15

0 166

题解 | #最差是第几名(二)#

SELECT grade FROM (SELECT * ,SUM(NUMBER) OVER(ORDER BY grade) AS up_rank ,SUM(NUMBER) OVER(ORDER BY grade DESC) AS down_rank ,SUM(NU...

2024-01-15

2 164

题解 | #最差是第几名(一)#

SELECT grade ,MAX(t_rank) AS t_rank FROM (SELECT * ,SUM(NUMBER) OVER(ORDER BY grade ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS t...

2024-01-15

0 170

题解 | #牛客的课程订单分析(六)#

SELECT id ,is_group_buy ,IF(is_group_buy='NO',NAME,NULL) AS client_name FROM (SELECT a.id ,user_id ,product_name ...

2024-01-15

0 178

题解 | #牛客的课程订单分析(五)#

SELECT DISTINCT user_id,first_buy_date,DATE AS second_buy_date,cnt FROM (SELECT * ,COUNT(product_name) OVER(PARTITION BY user_id) AS cnt ...

2024-01-15

0 189