谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共129篇）

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

select user_id, max(date) as date from login group by user_id order by user_id

2026-01-09

0 18

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

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

2026-01-09

0 17

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

with grade_cnt as ( select number, count(number) as cnt from grade group by number ) select number ...

2026-01-09

0 12

题解 | 统计salary的累计和running_total

select emp_no, salary, sum(salary) over(order by emp_no) as running_total from salaries where to_date = '9999-01-01'

2026-01-09

0 18

题解 | 获取有奖金的员工相关信息。

with employeed_salary as ( select emp_no, salary from salaries where to_date = '9999-01-01' ), employee...

2026-01-09

0 13

题解 | 平均工资

with employed as ( select * from salaries where to_date = '9999-01-01' ), salary_bound as ( select max(sala...

2026-01-08

0 16

题解 | 使用join查询方式找出没有分类的电影id以及名称

select f.film_id, f.title from film as f left join film_category as f_c on f.film_id = f_c.film_id where f_c.category_id ...

2026-01-08

0 15

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

with count_titles_emp as ( select d_e.dept_no, t.title, count(t.title) as count from dept_emp as d_e le...

2026-01-08

0 17

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

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

2026-01-08

0 14

题解 | 查找所有员工的last_name和first_name以及对应的dept_name

with total_departments as ( select d_e.emp_no, d_e.dept_no, d.dept_name from dept_emp as d_e left join ...

2026-01-08

0 26