Interested to Buy Any Domain ? << Click Here >> for more details...
Select * from emp,dept,loc where emp.deptno left outer join
dept.deptno and dept.locno=loc.locno.
No need to consider the syntax but is it possible to have
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the
same SQL ---
- 1 Answers
- 7773 Views
- Principal Finance, PT Metalogix Infolink Persada, I also Faced
- E-Mail Answers
Answer Posted / mayur
You can very well put Inner / Left Outer / Right Outer join
in the same SQL Query.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is data analytics in simple terms?
Do you view contain data?
What are the different types of fact tables used in data warehousing?
What is the function of surrogate key in data warehousing?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is prompt types of prompts?use of prompts syntax of prompt?
How many project sources we can create in metadata?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How to limit the max no of rows retrieved in the report?
Compare and contrast aggregates & indexes
What is the difference between datawarehouse and bi?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain the hierarchies level data warehousing.
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are data validation strategies for data mart validation after loading process?
