Lateral

分类

/ 注册

全部文章（共115篇）

题解 | 将所有获取奖金的员工当前的薪水增加10%

update salaries set salaries.salary=salaries.salary*1.1 where salaries.to_date='9999-01-01' and salaries.emp_no in(select emp_no from emp...

2025-05-24

0 40

题解 | 在audit表上创建外键约束，其emp_no对应employees_test表的主键id

alter table audit add constraint fk foreign key (emp_no) references employees_test(id) on delete cascade on update cascade

2025-05-24

0 38

题解 | 将id=5以及emp_no=10001的行数据替换成id=5以及emp_no=10005

update titles_test set emp_no=replace(emp_no,10001,10005) where id=5 and emp_no=10001

2025-05-24

0 28

题解 | 基本数学函数

select id, value, abs(value) as absolute_value, ceil(value) as ceiling_value, floor(value) as floor_value, round(value,1) as rounded_value from number...

2025-05-24

0 43

题解 | 计算每日累计利润

select *, case when lag(profit,1) over (order by profit_date asc) is null then profit else sum(profit) over (order by profit_...

2025-05-24

0 50

题解 | 电话号码格式校验

select * from contacts where (phone_number rlike '^\\d{10}$' and phone_number not rlike '^0') or (phone_number rlike '^\\d{3}\\-\\d...

2025-05-24

0 27

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

select d.dept_no, m.dept_name, t.title, count(*) as count from dept_emp d left join titles t on d.emp_no=t.emp_no left...

2025-04-28

0 35

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

with t1 as(select a.emp_no, b.emp_no as manager_no from dept_emp a left join dept_manager b on a.dept_no=b.dept_no and a.emp_no<>b.emp_no) se...

2025-04-27

0 36

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

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

2025-04-25

0 42

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

select a.emp_no, a.final_salary-b.initial_salary as growth from (select t.emp_no, s.salary as final_salary, t.final_date from (select emp_no...

2025-04-25

0 47