不想上网课的高级磨洋工练习时长两年半

分类

/ 注册

全部文章（共69篇）

题解 | 找到每个人的任务

select B.id,B.name,A.content from task A right join person B on A.person_id = B.id

2025-10-11

0 23

题解 | 刷题通过的题目排名

select id,number,dense_rank() over(order by number DESC) as t_rank from passing_number

2025-10-10

0 18

题解 | 出现三次以上相同积分的情况

select number from grade group by number having count(id) >= 3

2025-10-10

0 15

题解 | 给出employees表中排名为奇数行的first_name

select B.first_name as first from employees C INNER join (select first_name,rk from (select first_name, row_number() over(order by first_name) as rk...

2025-10-10

0 24

题解 | 查找字符串中逗号出现的次数

select id,char_length(string)-char_length(replace(string,',','')) as cnt from strings

2025-10-07

0 23

题解 | 纠错4

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers ...

2025-10-03

0 24

题解 | 汇总各个部门当前员工的title类型的分配数目

select C.dept_no,C.dept_name,D.title,count(D.title) as count from (select A.dept_no,A.dept_name,B.emp_no from departments A left join dept_emp B on A...

2025-10-02

0 17

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select s1.emp_no,s2.emp_no as manager_no,s1.salary as emp_salary, s2.salary as manager_salary from (select A.dept_no, A.emp_no,B.salary from dept_emp...

2025-10-02

0 20

题解 | 获取所有非manager员工当前的薪水情况

select C.dept_no,C.emp_no,D.salary from (select B.dept_no,A.emp_no from employees A left join dept_emp B on A.emp_no = B.emp_no) as C left join salar...

2025-10-02

0 22

题解 | 对所有员工的薪水按照salary降序进行1-N的排名

select emp_no,salary, dense_rank() over(order by salary DESC) as t_rank from salaries

2025-10-02

0 18