How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 16847 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
full outer join.
select ename,sal,dname,loc,e.deptno from emp e
full outer join dept d on e.deptno=d.deptno;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is rownum in sql?
Can we use two order by clause in query?
I need a function for a train ticket reservation please answer it thanks in advance
How do I save a stored procedure?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is delimiter in pl sql?
What is difference between pl and sql?
Explain the difference between drop and truncate commands in sql?
What is exception? What are the types of exceptions?
how to delete an existing column in a table? : Sql dba
What is the use of stored procedures?
Why do we use partitions in sql?
Are sql connections encrypted?
Why is pl sql used?
What is dense_rank in sql?
