牛客532930148号
牛客532930148号
全部文章
分类
题解(20)
归档
标签
去牛客网
登录
/
注册
牛客532930148号的博客
全部文章
(共20篇)
题解 | #考试分数(三)#
select a.id, language.name, a.score from (select id, language_id, score, dense_rank()over(partition by language_id order by score desc) posn fro...
Mysql
2022-05-11
0
151
题解 | #考试分数(四)#
select co.job, case when c%2=1 then round((c+1)/2,0) else round(c/2,0) end as start, case when c%2=1 then round((c+1)/2,0) else round((c/2...
Mysql
2022-05-11
0
155
题解 | #考试分数(五)#
select r.id, r.job, r.score, r.t_rank from (select co.job job, co.c number, case when c%2=1 then round((c+1)/2,0) else round(c/2,0) end as...
Mysql
2022-05-11
0
161
题解 | #给出employees表中排名为奇数行的first_name#
select first_name from employees where employees.emp_no in (select emp_no from (select emp_no, rank()over(order by first_name asc) posn from emp...
Mysql
2022-05-06
0
122
题解 | #获取有奖金的员工相关信息。#
SELECT employees.emp_no, employees.first_name, employees.last_name, emp_bonus.btype, salaries.salary, CASE WHEN emp_bonus.btype = 1 THEN round(s...
Mysql
2022-05-06
0
129
题解 | #汇总各个部门当前员工的title类型的分配数目#
select distinct dept_emp.dept_no, dept_name,titles.title, count(dept_emp.emp_no) from dept_emp left join titles on dept_emp.emp_no=titles.emp_no ...
Mysql
2022-05-05
0
178
题解 | #统计各个部门的工资记录数#
select departments.dept_no, dept_name, count(salaries.salary) from dept_emp left join departments on dept_emp.dept_no=departments.dept_no right join s...
Mysql
2022-05-04
0
120
题解 | #查找在职员工自入职以来的薪水涨幅情况#
select st.emp_no, en.salary-st.salary growth from (select employees.emp_no emp_no, salary from employees right join salaries on employees.emp_no=salar...
Mysql
2022-05-04
0
148
题解 | #统计各个部门的工资记录数#
select dept_no, salaries.emp_no, salary from salaries left join dept_emp on salaries.emp_no=dept_emp.emp_no where salaries.emp_no not in (select emp_n...
Mysql
2022-05-04
0
171
题解 | #统计各个部门的工资记录数#
select emps.emp_no, mans.emp_no, emps.salary, mans.salary from (select dept_emp.emp_no,salaries.salary salary, dept_emp.dept_no dept_no ...
Mysql
2022-05-04
0
113
首页
上一页
1
2
下一页
末页