Lateral

分类

/ 注册

全部文章（共102篇）

题解 | 基本数学函数

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 38

题解 | 计算每日累计利润

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 36

题解 | 电话号码格式校验

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 22

题解 | 汇总各个部门当前员工的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 24

题解 | 获取员工其当前的薪水比其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 24

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

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

2025-04-25

0 30

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

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 36

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

select e.last_name, e.first_name, p.dept_name from employees e left join dept_emp d on e.emp_no=d.emp_no left join departments p on d.dept_no=p.dept_n...

2025-04-03

0 31

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

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

2025-04-03

0 28

题解 | 获取每个部门中薪水最高的员工相关信息

select t.dept_no, t.emp_no, t.salary from (select e.emp_no, e.dept_no, s.salary, row_number() over(partition by e.dept_no order by s.salary desc) as...

2025-04-02

0 35