Оцените презентацию от 1 до 5 баллов!
Тип файла:
ppt / pptx (powerpoint)
Всего слайдов:
9 слайдов
Для класса:
1,2,3,4,5,6,7,8,9,10,11
Размер файла:
63.13 kB
Просмотров:
65
Скачиваний:
0
Автор:
неизвестен
Слайды и текст к этой презентации:
№1 слайд![Базы данных Лекция Язык SQL.](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img0.jpg)
Содержание слайда: Базы данных
Лекция 9
Язык SQL.
Соединение таблиц
№2 слайд![JOIN INNER OUTER LEFT OUTER](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img1.jpg)
Содержание слайда: JOIN
INNER
OUTER
LEFT OUTER
RIGHT OUTER
FULL OUTER
CROSS
№3 слайд![INNER JOIN SELECT table](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img2.jpg)
Содержание слайда: INNER JOIN
SELECT table1.column, table2.column, …
FROM table1
[INNER] JOIN table2 ON (<condition>);
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);
№4 слайд![INNER JOIN SELECT employee](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img3.jpg)
Содержание слайда: 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;
№5 слайд![INNER JOIN SELECT e.employee](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img4.jpg)
Содержание слайда: 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;
№6 слайд![INNER JOIN SELECT e.last](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img5.jpg)
Содержание слайда: 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;
№7 слайд![OUTER JOIN SELECT table](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img6.jpg)
Содержание слайда: OUTER JOIN
SELECT table1.column, table2.column, …
FROM table1
LEFT|RIGHT|FULL OUTER JOIN table2
ON (table1.column_name = table2.column_name);
№8 слайд![OUTER JOIN SELECT e.last](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img7.jpg)
Содержание слайда: 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);
№9 слайд![CROSS JOIN SELECT table](/documents_6/e415afa8776adce4acfdca7db7c5c17f/img8.jpg)
Содержание слайда: 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;