大行行
大行行
全部文章
分类
题解(21)
归档
标签
去牛客网
登录
/
注册
大行行的博客
全部文章
(共17篇)
题解 | #刷题通过的题目排名#
select id,number,dense_rank() over(order by number desc) as t_rank from passing_numberorder by t_rank,id排序函数:dense_rank(),按值排序,值相等时会重复,不会产生空位;
2021-08-12
0
289
题解 | #牛客的课程订单分析(一)#
select * from order_infowhere date>"2025-10-15"and status = 'completed'and product_name in('C++','Python','Java')order by id
2021-08-09
0
264
题解 | #获得积分最多的人(一)#
select user.name,t.grade_sum from(select user_id,sum(grade_num) as grade_sum from grade_info group by user_id order by grade_sum desc limit 1) tjoin u...
2021-08-06
0
238
题解 | #查找排除当前最大、最小salary之后的员工的平均工资avg_salary#
select avg(salary) as avg_salary from salarieswhere to_date = '9999-01-01' andsalary not in (select min(salary) from salaries where to_date = '9999-01...
2021-08-05
0
236
题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
select f.title,f.description from film as f inner join film_category as fc on f.film_id = fc.film_idinner join category as c on c.category_id = fc.cat...
2021-07-30
0
320
题解 | #使用join查询方式找出没有分类的电影id以及名称#
select f.film_id,f.title fromfilm as f left join film_category as fc on f.film_id = fc.film_idleft join category as c on c.category_id = fc.category_i...
2021-07-30
0
314
题解 | #汇总各个部门当前员工的title类型的分配数目#
select d.dept_no,d.dept_name,t.title,count(*) fromdepartments as d inner join dept_emp as de on d.dept_no = de.dept_noinner join titles as t on t.emp_...
2021-07-29
0
313
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
SELECT emp_no,manager_no,emp_salary,manager_salaryFROM(SELECT de.emp_no,dept_no,salary AS emp_salaryFROM dept_emp AS de INNER JOIN salaries AS s1ON de...
2021-07-29
0
307
题解 | #获取所有非manager员工当前的薪水情况#
select de.dept_no,s.emp_no,s.salary from employees as einner join dept_emp as de on e.emp_no = de.emp_noinner join salaries as s on de.emp_no = s.emp_...
2021-07-29
0
260
题解 | #统计各个部门的工资记录数#
select de.dept_no,d.dept_name,count(s.emp_no) as sum from departments as d inner join dept_emp as de on d.dept_no = de .dept_noinner join salaries as ...
2021-07-28
0
235
首页
上一页
1
2
下一页
末页