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
Explain the role of indexing in databases?
Explain about the storage and physical database design?
How you can make a parameterized view?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How can you fix a poorly performing query?
Explain about network model?
What are the types of database model?
Write the fastest query to find out how many rows exist in a table?
What is DB Development software?
What is dbms and its application?
Explain about relational database management systems?
In which database can extended stored procedures be added?
How to use timestamp datatypes
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
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?