存几分期许

分类

/ 注册

全部文章（共167篇）

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

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

2025-08-16

0 47

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

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

2025-08-16

0 31

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

select first_name as first from ( select first_name, row_number() over () as rn1, -- 原顺序 row_number() over (order by first_name) as rn2 ...

2025-08-16

0 37

题解 | 统计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"

2025-08-16

0 41

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

select a.emp_no, first_name, last_name, btype, salary, round( case when btype=1 then salary*0.1 when btype=2 then salary*0.2 else salary*0...

2025-08-16

0 38

题解 | 使用含有关键字exists查找未分配具体部门的员工的所有信息。

select * from employees where not exists ( select emp_no from dept_emp where employees.emp_no = dept_emp.emp_no )

2025-08-16

0 41

题解 | 分页查询employees表，每5行一页，返回第2页的数据

select * from employees limit 5, 5

2025-08-16

0 40

题解 | 平均工资

select avg(salary) as avg_salary from salaries where to_date = '9999-01-01' and salary<>(select max(salary) from salaries where to_date = '9999-...

2025-08-16

0 28

题解 | 最差是第几名(二)

with t1 as ( select floor(((select sum(number) from class_grade)+1)/2) as thr union all select ceil(((select sum(number) from class_grade)...

2025-08-16

0 27

题解 | 按照dept_no进行汇总

select dept_no, group_concat(emp_no) from dept_emp group by dept_no

2025-08-15

0 27