JerryCoCo
JerryCoCo
全部文章
题解
面经(2)
归档
标签
去牛客网
登录
/
注册
CoCoBaBy
全部文章
/ 题解
(共16篇)
题解 | #回文数字#
import java.util.*; public class Solution { /** * * @param x int整型 * @return bool布尔型 */ public boolean isPalindrome (i...
Java
2021-10-08
0
308
题解 | #实习广场投递简历分析(三)#
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
题解 | #牛客的课程订单分析(二)#
sql分步计算 SELECT a.user_id, b.first_buy_date, a.cnt FROM ( SELECT user_id,COUNT(1) AS cnt FROM order_info WHERE date > '2025-10-15' AND status='comp...
2021-09-14
0
337
题解 | #牛客的课程订单分析(一)#
SQL分步操作 SELECT id,user_id,product_name,status,client_id,date FROM order_info WHERE -- 日期大于'2025-10-15' date > '2025-10-15' AND -- 状态为 completed st...
2021-09-07
0
235
题解 | #考试分数(五)#
sql分解步骤,在之前的步骤之上进行排序即可 SELECT k.id,k.job,k.score,k.number AS t_rank FROM ( SELECT id,job,score, RANK() OVER(PARTITION BY job ORDER BY score DESC,job)...
2021-09-07
0
298
题解 | #考试分数(四)#
mysql分步操作 SELECT a.job, CASE (MIN(a.number) + MAX(a.number))%2 WHEN 0 THEN ROUND((MIN(a.number) + MAX(a.number))/2,0) ELSE F...
2021-09-07
0
241
题解 | #考试分数(三)#
-- 求结果排序 SELECT c.id,d.`name`,c.score FROM language d, ( SELECT a.id,a.language_id,a.score,a.number FROM( -- 按排名去top2的language SELECT id,language_id...
2021-09-06
0
250
首页
上一页
1
2
下一页
末页