- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Язык SQL. Соединение таблиц. (Лекция 9) презентация
Содержание
- 1. Язык SQL. Соединение таблиц. (Лекция 9)
- 2. JOIN INNER OUTER LEFT OUTER RIGHT OUTER FULL OUTER CROSS 18.11.2017 Горбунов О.Е.
- 3. INNER JOIN SELECT table1.column, table2.column, …
- 4. INNER JOIN SELECT employee_id, city, department_name
- 5. INNER JOIN SELECT e.employee_id, e.last_name, e.department_id,
- 6. INNER JOIN SELECT e.last_name, e.salary, j.grade_level
- 7. OUTER JOIN SELECT table1.column, table2.column, …
- 8. OUTER JOIN SELECT e.last_name, e.department_id, d.department_name
- 9. CROSS JOIN SELECT table1.column, table2.column, …
JOIN INNER OUTER LEFT OUTER RIGHT OUTER FULL OUTER CROSS 18.11.2017 Горбунов О.Е.
Слайд 3
INNER JOIN
SELECT table1.column, table2.column, …
FROM table1
[INNER] JOIN table2 ON ();
SELECT e.employee_id,
e.last_name, e.department_id, d.department_id, d.location_id
FROM employees e JOIN departments d
ON(e.department_id = d.department_id);
SELECT worker.last_name emp, manager.last_name mgr
FROM employees worker JOIN employees manager
ON (worker.manager_id = manager.employee_id);
FROM employees e JOIN departments d
ON(e.department_id = d.department_id);
SELECT worker.last_name emp, manager.last_name mgr
FROM employees worker JOIN employees manager
ON (worker.manager_id = manager.employee_id);
18.11.2017
Горбунов О.Е.
Слайд 4
INNER JOIN
SELECT employee_id, city, department_name
FROM employees e
JOIN departments d
ON d.department_id
= e.department_id
JOIN locations l
ON d.location_id = l.location_id;
JOIN locations l
ON d.location_id = l.location_id;
18.11.2017
Горбунов О.Е.
Слайд 5
INNER JOIN
SELECT e.employee_id, e.last_name, e.department_id,
d.department_id, d.location_id
FROM
employees e JOIN departments d
ON (e.department_id = d.department_id
AND e.manager_id = 149);
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
WHERE e.manager_id = 149;
ON (e.department_id = d.department_id
AND e.manager_id = 149);
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
WHERE e.manager_id = 149;
18.11.2017
Горбунов О.Е.
Слайд 6
INNER JOIN
SELECT e.last_name, e.salary, j.grade_level
FROM employees e JOIN job_grades j
ON e.salary
BETWEEN j.lowest_sal AND j.highest_sal;
18.11.2017
Горбунов О.Е.
Слайд 7
OUTER JOIN
SELECT table1.column, table2.column, …
FROM table1
LEFT|RIGHT|FULL OUTER JOIN table2
ON (table1.column_name
= table2.column_name);
18.11.2017
Горбунов О.Е.
Слайд 8
OUTER JOIN
SELECT e.last_name, e.department_id, d.department_name
FROM employees e LEFT OUTER JOIN departments
d
ON (e.department_id = d.department_id);
SELECT e.last_name, e.department_id, d.department_name
FROM employees e RIGHT OUTER JOIN departments d
ON (e.department_id = d.department_id);
SELECT e.last_name, e.department_id, d.department_name
FROM employees e FULL OUTER JOIN departments d
ON (e.department_id = d.department_id);
ON (e.department_id = d.department_id);
SELECT e.last_name, e.department_id, d.department_name
FROM employees e RIGHT OUTER JOIN departments d
ON (e.department_id = d.department_id);
SELECT e.last_name, e.department_id, d.department_name
FROM employees e FULL OUTER JOIN departments d
ON (e.department_id = d.department_id);
18.11.2017
Горбунов О.Е.
Слайд 9
CROSS JOIN
SELECT table1.column, table2.column, …
FROM table1
CROSS JOIN table2;
SELECT last_name, department_name
FROM employees
CROSS JOIN
departments;
SELECT last_name, department_name
FROM employees, departments;
SELECT last_name, department_name
FROM employees, departments;
18.11.2017
Горбунов О.Е.
