newbee松

分类

题解(4)

/ 注册

全部文章（共4篇）

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

select t.user_id, t.first_buy_date, t.num from(select , count() over(partition by user_id) as num,min(date) over(partition by user_id) as first_buy_da...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 378

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

select t.id,t.user_id,t.product_name,t.status,t.client_id,t.datefrom(select , count() over(partition by user_id) as numfrom order_infowhere product_na...

SQL 窗口函数 sql高阶开窗函数

2021-07-11

2 528

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

select T.*from ( select * from order_info where date > '2025-10-15' and product_name in ('C++', 'Python', 'Java') and status = 'comp...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 465

题解 | #考试分数(三)#

select a.id, a.name, a.scorefrom (select g.id,g.score,l.name, dense_rank() over(partition by l.id order by g.score desc) rk from grade g lef...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 394