🗊Презентация Язык SQL. Соединение таблиц. (Лекция 9)

Категория: Информатика
Нажмите для полного просмотра!
Язык SQL. Соединение таблиц. (Лекция 9), слайд №1Язык SQL. Соединение таблиц. (Лекция 9), слайд №2Язык SQL. Соединение таблиц. (Лекция 9), слайд №3Язык SQL. Соединение таблиц. (Лекция 9), слайд №4Язык SQL. Соединение таблиц. (Лекция 9), слайд №5Язык SQL. Соединение таблиц. (Лекция 9), слайд №6Язык SQL. Соединение таблиц. (Лекция 9), слайд №7Язык SQL. Соединение таблиц. (Лекция 9), слайд №8Язык SQL. Соединение таблиц. (Лекция 9), слайд №9
Скачать
Вы можете ознакомиться и скачать презентацию на тему Язык SQL. Соединение таблиц. (Лекция 9). Доклад-сообщение содержит 9 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1


Базы данных Лекция 9 Язык SQL. Соединение таблиц
Описание слайда:
Базы данных Лекция 9 Язык SQL. Соединение таблиц

Слайд 2


JOIN INNER OUTER LEFT OUTER RIGHT OUTER FULL OUTER CROSS
Описание слайда:
JOIN INNER OUTER LEFT OUTER RIGHT OUTER FULL OUTER CROSS

Слайд 3


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);
Описание слайда:
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_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;
Описание слайда:
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_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;
Описание слайда:
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_name, e.salary, j.grade_level FROM employees e JOIN job_grades j ON e.salary BETWEEN j.lowest_sal AND j.highest_sal;
Описание слайда:
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 table1.column, table2.column, … FROM table1 LEFT|RIGHT|FULL OUTER JOIN table2 ON (table1.column_name = table2.column_name);
Описание слайда:
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_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);
Описание слайда:
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 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;
Описание слайда:
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;

Скачать

Похожие презентации
Mypresentation.ru
Загрузить презентацию