yangdongaaa

SQL题解

Python题解(66) 声明(1) 题解(13)

/ 注册

全部文章 / SQL题解（共4篇）

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

M.emp_no AS emp_no, N.emp_no AS manager_no, M.salary AS emp_salary, N.salary AS manager_salary FROM ( -- 员工薪水 SELECT T1.emp_no, T1.salary, T2.dept_no...

Sqlite

2021-11-19

0 366

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

SELECT T2.dept_no, T1.emp_no, T4.Salary FROM employees T1 LEFT JOIN dept_emp T2 ON T1.emp_no = T2.emp_no LEFT JOIN salaries T4 ON T1.emp_no = T4.em...

Sqlite

2021-11-19

1 342

题解 | #统计各个部门的工资记录数#

T.DEPT_NO, T.DEPT_NAME, COUNT(DEPT_NO) OVER(PARTITION BY DEPT_NO) AS SN FROM ( SELECT T1.DEPT_NO, T1.DEPT_NAME, T3.SALARY FROM departments T1 LEFT JOI...

Sqlite

2021-11-19

0 243

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

T2.NUMBER FROM ( SELECT NUMBER, COUNT(ID) OVER(PARTITION BY NUMBER) AS CN FROM GRADE )T2 WHERE T2.CN >= 3 GROUP BY T2.NUMBER

Sqlite

2021-11-19

0 291