Seay.L
Seay.L
全部文章
分类
题解(7)
归档
标签
去牛客网
登录
/
注册
Seay.L的博客
全部文章
(共7篇)
题解 | #获得积分最多的人(三)#
with grade_add as( select user_id,sum(grade_num) as ad from grade_info where type='add' group by user_id),grade_reduce as( select user_...
2021-08-31
0
234
题解 | #牛客每个人最近的登录日期(二)#
select date, ifnull(round((sum(case when (user_id,date)in(select user_id,date_add(date,interval -1 day) from login)--给login中所有日期都减一,判断是否在其中,即判断用...
2021-08-10
0
320
题解 | #牛客每个人最近的登录日期(二)#
select u.name as u_n,c.name as c_n,l.date from user as u inner join login as l on u.id=l.user_id inner join client as c on l.client_id=c.id where l.da...
2021-08-09
0
266
题解 | #对于employees表中,给出奇数行的first_name#
select first_namefrom employeeswhere first_name in (select first_name --判断first_name是否在符合题目条件的表中from(select first_name,row_number() over(order by fi...
2021-08-09
0
260
题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目,而且还需要该分类对应电影数量>=5部#
select c.name,count(a.film_id)from film as aleft join film_category as b on a.film_id=b.film_idinner join category as c on b.category_id=c.category_id...
2021-08-06
0
309
题解 | #找出所有员工当前薪水salary情况#
select a.emp_no,c.emp_no as manager_no,b.salary as emp_salary, (select salary from salaries where emp_no=c.emp_no and to_date='9999-...
2021-08-06
0
221
题解 | #查找入职员工时间排名倒数第三的员工所有信息#
select * from employeeswhere hire_date = ( select hire_date from employees group by hire_date order by hire_date desc limit 2,1)因为可能会有很多员工同时入职,所...
2021-08-06
1
208