sjd_

分类

/ 注册

全部文章（共13篇）

查找字符串中逗号出现的次数

-- length + replace select id, length(string)-length(replace(string, ',', '')) as cnt from strings

2024-11-07

1 25

获取当前薪水第二多的员工及其对应的薪水salary

-- 使用自连接 select e.emp_no, s.salary, last_name, first_name from employees e left join salaries s on e.emp_no = s.emp_no where e.emp_no = ( select s...

2024-11-07

1 24

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

select t1.emp_no as emp_no, t2.emp_no as manager_no, t1.salary as emp_salary, t2.salary as manager_salary from (select d_e.emp_no, s1.salary, d_e.dep...

2024-11-07

1 13