zyt33
zyt33
全部文章
分类
题解(20)
归档
标签
去牛客网
登录
/
注册
zyt33的博客
全部文章
(共17篇)
题解 | #牛客的课程订单分析(五)#
SELECT id,is_group_buy , name client_name FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) rn FROM ( SELECT o.* ,c.name FROM order_info o LEFT JOIN ...
Mysql
2022-01-27
0
176
题解 | #牛客的课程订单分析(四)#
SELECT * FROM order_info; SELECT user_id,MIN(DATE),cnt FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) cnt FROM order_info WHERE status='completed' ...
Mysql
2022-01-26
0
232
题解 | #牛客的课程订单分析(四)#
SELECT user_id,MIN(DATE),cnt FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) cnt FROM order_info WHERE status='completed' AND product_name IN ('c++'...
Mysql
2022-01-26
0
149
题解 | #牛客的课程订单分析(三)#
SELECT id,user_id,product_name,status,client_id,date FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) a FROM order_info WHERE product_name IN ('c++',...
Mysql
2022-01-26
0
121
题解 | #考试分数(五)#
SELECT id,job, score, t_rank FROM (SELECT a.id, a.job, a.score, RANK() OVER (PARTITION BY job ORDER BY score DESC) t_rank,b.start,b.end FROM grade a L...
Mysql
2022-01-26
0
180
题解 | #考试分数(二)#
SELECT job, CASE WHEN COUNT(job)%2=0 THEN TRUNCATE(COUNT(job)/2,0) ELSE TRUNCATE(FLOOR(COUNT(job)/2)+1,0) END start , CASE WHEN COUNT(job)%2=0 THEN T...
Mysql
2022-01-14
0
180
题解 | #牛客每个人最近的登录日期(六)#
SELECT u.name u_n,DATE, (SELECT SUM(number) FROM passing_number p1 WHERE p1.date <= p2.date AND p1.user_id = p2.user_id) ps_num FROM passing_numbe...
Mysql
2022-01-13
0
194
首页
上一页
1
2
下一页
末页