Owen433

分类

/ 注册

全部文章（共65篇）

题解 | #考试分数(三)#

select t2.id, t3.name, t2.score from ( select *, dense_rank() over(partition by t1.language_id order by t1.score desc...

2023-09-16

0 229

题解 | #牛客每个人最近的登录日期(二)#

select t2.name u_n, t3.name c_n, t1.date from login t1 join user t2 on t1.user_id = t2.id join client t3 on t1.client_id = ...

2023-09-16

0 209

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

select t4.first_name from (select first_name, sum(1) over (rows between unbounded preceding and current row) rank1 from ...

2023-09-15

0 322

题解 | #获取所有员工当前的manager#

select dept_emp.emp_no, dept_manager.emp_no from dept_emp, dept_manager where dept_emp.dept_no = dept_manager.dept_no and dept...

2023-09-13

0 257

题解 | #查找最晚入职员工的所有信息#

select * from employees order by hire_date desc limit 1 offset 0

2023-09-12

1 235