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
Why does this query return 0?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the 18 schemas?
Explain about the hierarchical model of the database?
Explain about relational database management systems?
Who are end users in dbms?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain the rollup operator?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
State the acid rules?
What are the key features of dbms?
Explain the role of indexing in databases?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What are the main phases of database development?
Explain about network model?