Basic SQL(Join) Operations | SCOTT/TIGER SCHEMA | ORACLE SQL | Part-5

Published: 20 March 2020
on channel: Basic Code

509

1. List employee name, department number and their corresponding department name by joining EMP and DEPT tables
2. List employee name and their manager name by joining EMP table to itself
3. List employee name, department name and their grade by joining EMP, DEPT and SALGRADE tables
4. List employees who work in ‘Research’ department by joining EMP and DEPT tables
5. List all rows from EMP table and only the matching rows from DEPT table – LEFT OUTER JOIN
6. List only matching rows from EMP table and all rows from DEPT table – RIGTH OUTER JOIN
7. Write a query to perform full outer join between EMP and DEPT tables
8. List employee name, their manager name and their manager’s manager name

On this page of the site you can watch the video online Basic SQL(Join) Operations | SCOTT/TIGER SCHEMA | ORACLE SQL | Part-5 with a duration of hours minute second in good quality, which was uploaded by the user Basic Code 20 March 2020, share the link with friends and acquaintances, this video has already been watched 509 times on youtube and it was liked by 12 viewers. Enjoy your viewing!

749