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 |
Post New Answer View All Answers
What is the difference between nvl function, ifnull function, and isnull function?
how to run 'mysql' commands from a batch file? : Sql dba
what is column? : Sql dba
how do you know if your mysql server is alive? : Sql dba
Explain what is table in a database?
What are pl sql data types?
Define select, insert, create, delete, update, drop keywords
Is primary key is clustered index?
Does inner join return duplicate rows?
What are actual parameters and formal parameters?
what is unique key constraint? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the basic structure of an sql?
How do I kill a query in postgresql?
What is before trigger?