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 use of double ampersand (&&) in sql queries?
What are the different ddl commands in sql?
What is the meaning of disabling a trigger?
What is a clob in sql?
What is the difference between instead of trigger and after trigger?
What are the types of variables use in pl sql?
What is a sql schema used for?
What is trigger in sql?
what is log shipping? : Sql dba
What are properties of the transaction?
Why should I use postgresql?
What are the possible values that can be stored in a boolean data field?
Why do we use procedures?
What schema means?
What packages are available to pl/sql developers?
