超超i7宝

题解

/ 注册

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

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

SELECT *FROM employeesWHERE employees.emp_no%2 = 1ORDER BY employees.hire_date DESC

2020-11-15

0 676

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

SELECT title, count(emp_no) nFROM titlesGROUP BY titleHAVING n >= 2

2020-11-15

0 448

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

SELECT a.dept_no, a.emp_no, MAX(sal.salary)FROM dept_emp a left join salaries salON a.emp_no = sal.emp_noWHERE a.to_date = '9999-01-01' and sal.to_dat...

2020-11-15

1 559

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

SELECT emp.emp_no, manager.emp_noFROM dept_emp emp, dept_manager managerWHERE emp.emp_no != manager.emp_noAND emp.dept_no = manager.dept_noAND manager...

2020-11-15

1 439

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

SELECT emp_no FROM employeesWHERE emp_no NOT IN(SELECT emp_no FROM dept_manager)

2020-11-14

1 487

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

SELECT dept_manager.dept_no, dept_manager.emp_no, salaries.salary FROM dept_manager, salariesWHERE salaries.to_date = '9999-01-01' AND dept_manager.to...

2020-11-14

2 578

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

select emp_no, count(emp_no) as tfrom salariesgroup by emp_nohaving t>15

2020-11-14

1 388

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

select e.emp_no, s.salaryfrom employees as e left join salaries as son e.emp_no = s.emp_no and e.hire_date = s.from_dateorder by e.emp_no desc

2020-11-14

0 443

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

select e.last_name, e.first_name, d.dept_nofrom employees as e left join dept_emp as don e.emp_no = d.emp_no

2020-11-14

1 514

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

select e.last_name, e.first_name, d.dept_nofrom employees as e inner join dept_emp as don e.emp_no = d.emp_no

2020-11-14

1 474