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

Publicado el: 20 marzo 2020
en el canal de: 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

En esta página del sitio puede ver el video en línea Basic SQL(Join) Operations | SCOTT/TIGER SCHEMA | ORACLE SQL | Part-5 de Duración hora minuto segunda en buena calidad , que subió el usuario Basic Code 20 marzo 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 509 veces y le gustó 12 a los espectadores. Disfruta viendo!

749