么的问题
么的问题
全部文章
题解
归档
标签
去牛客网
登录
/
注册
么的问题的博客
全部文章
/ 题解
(共10篇)
题解 | #商品交易(网易校招笔试真题)#
select t.goods_id id,g.name name,g.weight weight,sum(t.count) as 'total' from trans t left join goods g on g.id=t.goods_id group by t.goods_id having ...
Mysql
2021-12-12
0
208
题解 | #获得积分最多的人(三)#
select t.id,t.name,t.grade_sum from (select u.id,u.name,rank() over(order by g_sum desc) rnk,g.g_sum as 'grade_sum' from (select user_id, sum(case whe...
Mysql
2021-12-12
0
171
题解 | #获得积分最多的人(二)#
select u.id,u.name,sum(g.grade_num) as 'grade_sum' from user u join grade_info g on u.id=g.user_id group by u.id,u.name having grade_sum =(select sum(...
Mysql
2021-12-12
0
181
题解 | #获得积分最多的人(一)#
select u.name,sum(g.grade_num) over(partition by g.user_id) as grade_sum from user u inner join grade_info g on u.id=g.user_id order by grade_sum desc...
Mysql
2021-12-12
0
199
题解 | #考试分数(五)#
select t.id,t.job,t.score,t.num from (select id,job,score,row_number() over(partition by job order by score desc) num, count(score) over(partition by ...
Mysql
2021-12-03
0
198
题解 | #考试分数(四)#
select t.job, case when t.num%2=0 then round(t.num/2,0) else round((t.num+1)/2,0) end 'start', case when t.num%2=0 then round(t.num/2+1,0) else round...
Mysql
2021-12-03
0
326
题解 | #考试分数(三)#
select t3.id,t3.name,t3.score from (select t2.*,dense_rank() over(partition by t2.name order by t2.score desc) as 'rnk' from (select t1.id,t1.name,t1....
Mysql
2021-11-27
0
217
题解 | #牛客每个人最近的登录日期(四)#
select date,sum( case when (user_id,date) in (select user_id,min(date) from login group by date) then 1 else 0 end ) as new from login group by date o...
Mysql
2021-11-26
0
208
题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
select t2.last_name,t2.first_name,t2.dept_name from (select t.*,d2.dept_name from (select e.emp_no,d1.dept_no,e.last_name,e.first_name from employees ...
Mysql
2021-11-21
0
227
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
select * from ( select e.emp_no,s.salary,e.last_name,e.first_name from employees e inner join salaries s on e.emp_no=s.emp_no where salary!= (select m...
Mysql
2021-11-21
0
226