Full outer join select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname f

full outer join syntax

Question Posted / madhav

Answer Posted / madhav

Full outer join

select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname from
emp e full outer join dept d
on e.deptno=d.deptno;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the two virtual tables available at the time of database trigger execution?

1155

Is json a nosql?

914

How to fix oracle error ora-00942: table or view does not exist

954

What types of commands can be executed in sql*plus?

1048

What is string data type in sql?

1045

Which are sql * plus commands?

1039

What is trigger and how to use it in sql?

950

What is the usage of sql functions?

1073

Explain the rollback statement?

961

how to create a new table in mysql? : Sql dba

932

What is an exception in pl/sql?

1005

Explain locks? : Transact sql

949

How do you use join?

886

describe transaction-safe table types in mysql : sql dba

943

What are analytical functions in sql?

968