Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Different Types of Joins and How do They Work?
- 1 Answers
- 1985 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Using an inner join, records from both tables with matching values are retrieved.
All records from the left table and matched records from the right table are retrieved using a left join, also known as a left outer join. Records from the right table that don't match will be NULL.
All records from the right table and matched records from the left table are retrieved using a right join, also known as a right outer join. Records from the left table that don't match will be NULL.
When there is a match in either the left or right table, records are retrieved using a full join (full outer join). Records from both tables that don't match will be NULL.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention some advantages of using dbms.
What are the different types of keys in the database?
What are the characteristics of database management system?
How can you get the alternate records from the table in the sql?
Who is communication horizons?
What are service-specific middleware?
Explain database partitioning and its importance.
What is the function of DML Compiler?
What are the types of distributed database?
What is the best database software?
What's the difference between star and snow flake schema?
How to monitor firebird server activity?
How to tell firebird to only accept conections from xyz host or network?
Differentiate between nested loop, hash loop and merge join.
What are different type of normalization?
