超超i7宝

题解

/ 注册

全部文章 / 题解（共45篇）

数据库SQL实战 No.24 来自专栏

该题难点在于如何标注出 emp_no不等于 employees.emp_no 不等于 dept_manager.emp_no以下是代码： SELECT d.dept_no, e.emp_no, s.salaryFROM dept_emp d JOIN employees e ON d.emp_no ...

2020-11-24

0 497

数据库SQL实战 No.23 来自专栏

SELECT s.emp_no, s.salary, dense_rank() over (order by s.salary DESC) as rankFROM salaries sWHERE s.to_date = '9999-01-01'

2020-11-24

0 503

数据库SQL实战 No.22 来自专栏

SELECT d.dept_no, d.dept_name, count(s.salary) AS SUMFROM departments d JOIN dept_emp de ON d.dept_no = de.dept_noJOIN salaries s ON de.emp_no = s.emp...

2020-11-17

86 6785

数据库SQL实战 No.21 来自专栏

SELECT hire_date.emp_no, (up_to_date.salary-hire_date.salary) AS growthFROM (SELECT e.emp_no, s.salary FROM employees e JOIN salaries s ON e.e...

2020-11-17

0 567

数据库SQL实战 No.20 来自专栏

SELECT MAX(salary) - MIN(salary) AS growthFROM salariesWHERE emp_no = 10001

2020-11-17

0 568

数据库SQL实战 No.19 来自专栏

SELECT e.last_name, e.first_name, d.dept_nameFROM employees e LEFT JOIN dept_emp deON e.emp_no = de.emp_nolEFT JOIN departments dON de.dept_no = d.dep...

2020-11-17

0 581

数据库SQL实战 No.18 来自专栏

SELECT e.emp_no, s.salary, e.last_name, e.first_nameFrom employees e join salaries sON e.emp_no = s.emp_noWHERE s.to_date = '9999-01-01'ORDER BY s.sal...

2020-11-17

1 690

数据库SQL实战 No.14 来自专栏

SELECT DISTINCT title, COUNT(DISTINCT emp_no) tFROM titlesGROUP BY titleHAVING t >= 2

2020-11-17

0 457

数据库SQL实战 No.17 来自专栏

SELECT emp_no, salaryFROM salariesWHERE salary = (SELECT salary FROM salaries WHERE to_date = '9999-01-01' ...

2020-11-17

0 586

数据库SQL实战 No.16 来自专栏

SELECT title, avg(salary) as averageFROM titles t join salaries s on t.emp_no = s.emp_noWHERE t.to_date = '9999-01-01'AND s.to_date = '9999-01-01'GROU...

2020-11-17

0 576