皮蛋瘦瘦粥

分类

/ 注册

全部文章（共27篇）

获取员工其当前的薪水比其manager当前薪水还高

select es.emp_no,ms.manager_no,es.emp_salary,ms.manager_salary from #创建员工工资表 (select s.emp_no,de.dept_no,s.salary as emp_salary from salaries s joi...

2023-03-11

0 263

题解 | #获取所有非manager员工当前的薪水情况#

select d.dept_no,s.emp_no,s.salary from dept_emp d join salaries s on d.emp_no=s.emp_no where d.to_date='9999-01-01' and s.emp_no not in (select emp...

2023-03-10

0 207

不用order by找出salary第二多的员工

select e.emp_no,s1.salary,e.last_name,e.first_name from employees e inner join salaries s1 on e.emp_no=s1.emp_no where s1.salary=(select max(s2.salary...

2023-03-08

0 197

题解 | #获取薪水第二多的emp_no及对应的salary

#子查询方法 select emp_no,salary from salaries where salary = (select distinct salary from salaries order by salary desc limit 1,1) order by emp_no ; #...

2023-03-08

0 219

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

select d1.dept_no,d1.emp_no,s1.salary from dept_emp d1 inner join salaries s1 on d1.emp_no=s1.emp_no where s1.salary=( select max(s2.salary ) as m...

2023-03-08

0 152

题解

select emp_no,count(salary) as t from salaries group by emp_no having t>15

2023-03-07

0 197

题解 | #找出每个学校GPA最低的同学#

select device_id,university,gpa from user_profile a where gpa = ( select min(gpa) from user_profile where university=a.university) order by...

2023-03-06

0 180