How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 17748 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
Write a sql query to convert all character to uppercase after hypen.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is a .db file?
What is row_number () in sql?
Differentiate between % rowtype and type record.
What is scalar and vector?
What is java sql package?
How to assign sql query results to pl sql variables?
Can you upgrade sql express to full sql?
Is and as keyword in pl sql?
What is the use of double ampersand (&&) in sql queries? Give an example
What view means?
What is form and report?
How do I create a sql database?
define data blocks ? : Sql dba
