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 is the difference between nvl function, ifnull function, and isnull function?

1101

how to run 'mysql' commands from a batch file? : Sql dba

1108

what is column? : Sql dba

1000

how do you know if your mysql server is alive? : Sql dba

1076

Explain what is table in a database?

1055

What are pl sql data types?

1007

Define select, insert, create, delete, update, drop keywords

1038

Is primary key is clustered index?

996

Does inner join return duplicate rows?

970

What are actual parameters and formal parameters?

1101

what is unique key constraint? : Sql dba

1030

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1068

What is the basic structure of an sql?

1098

How do I kill a query in postgresql?

1097

What is before trigger?

997