谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共129篇）

题解 | 考试分数(三)

with grade_rank as ( select *, dense_rank() over (partition by language_id order by score desc) as rn from grade ) ...

2026-01-13

0 17

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

with min_login as ( select user_id, min(date) as min_date from login group by user_id ) select l.da...

2026-01-13

0 15

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

with min_login as ( select user_id, min(date) as min_date from login group by user_id ) select roun...

2026-01-13

0 17

题解 | 异常的邮件概率

select date, round(sum(type = 'no_completed') / count(type),3) as p from email where send_id in (select id from user where is_blackl...

2026-01-13

0 19

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

with employees_rank as ( select *, row_number() over(order by first_name) as rn from employees ) select e.first...

2026-01-13

0 17

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

select d_e.emp_no, d_m.emp_no as manager_no, s1.salary as emp_salary, s2.salary as manager_salary from dept_emp as d_e join d...

2026-01-12

0 15

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

# 经理的员工编号 with manager_no as ( select distinct emp_no from dept_manager ) select dept_emp.dept_no, emp_salaries.emp...

2026-01-12

0 18

题解 | 查找在职员工自入职以来的薪水涨幅情况

# 所有员工的入职工资 with hire_salaries as ( select e.emp_no, s.salary from employees as e left join salaries as...

2026-01-12

0 14

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select s.emp_no, s.salary, e.last_name, e.first_name from salaries as s left join employees as e on s.emp_no = e.emp_no...

2026-01-12

0 17

题解 | 今天的刷题量(一)

with submission_cnt as ( select subject_id, count(subject_id) as cnt from submission where create_time ...

2026-01-12

0 20