yangdongaaa

分类

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

/ 注册

全部文章（共76篇）

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

SELECT DISTINCT T1.dept_no, T2.dept_name, T3.title, COUNT(1) OVER(PARTITION BY T1.dept_no,T3.title) AS COUNT FROM dept_emp ...

Sqlite

2021-11-19

0 315

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

选择first_name按升序的奇数行，但是输出时不排序

T2.FIRST_NAME FROM EMPLOYEES T2, ( SELECT T1.FIRST_NAME, ROW_NUMBER() OVER(ORDER BY FIRST_NAME) AS RO FROM EMPLOYEES T1 )T3 WHERE T2.FIRST_NAME ...

Sqlite

2021-11-19

0 310