JerryCoCo
JerryCoCo
全部文章
分类
面经(2)
题解(16)
归档
标签
去牛客网
登录
/
注册
CoCoBaBy
全部文章
(共4篇)
题解 | #实习广场投递简历分析(三)#
SELECT t.id,t.name,t.num FROM ( SELECT a.id,a.`name`,a.num,DENSE_RANK() OVER(ORDER BY a.num DESC) number FROM ( ...
Mysql
2021-09-16
0
267
题解 | #实习广场投递简历分析(三)#
SELECT k.job,k.first_year_mon,k.first_year_cnt, l.scond_year_mon,l.scond_year_cnt FROM ( SELECT DISTINCT(a.job),a.date AS first_year_mon, SUM(a.num) A...
Mysql
2021-09-16
0
313
题解 | #实习广场投递简历分析(二)#
SELECT a.job,a.date, -- SUM(num) OVER(PARTITION BY job,date) AS cnt SUM(a.num) AS cnt FROM ( SELECT job,DATE_FORMAT(date,'%Y-%m') AS date,num FROM res...
Mysql
2021-09-15
0
216
题解 | #牛客的课程订单分析(五)#
SELECT a.user_id, b.first_buy_date, c.second_buy_date, a.cnt FROM ( SELECT user_id,COUNT(1) AS cnt FROM order_info WHERE date > '2025-10-15' AND s...
Mysql
2021-09-15
0
287