What is a join and explain different types of joins?
Answer Posted / dhivya
Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
fact table and dimension table containg one to many relationship or many to one relastionship
State the acid rules?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Write short notes on manual refreshes.
Why does this query return 0?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
How can you log an error to the server event log from a stored procedure?
Explain the role of indexing in databases?
Where is dbms used?
What are the key features of dbms?
Explain the rollup operator?
What is dbms explain in brief?
What is DB Development software?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What are the constraints on severity level in raiseerror?