What are joins and mention different types of joins?
Answer Posted / uma sravanthi
JOIN clause is used to combine rows from two or more tables, based on a related column between them.
The types are:
1. Inner Join
2.Outer Join
3.Left Join
4.Right Join
5.Full Join
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you know for database testing, whether trigger is fired or not?
What are the different types of database testing?
How to test procedures and triggers of a database?
What is difference between local and global temporary table?
Why database testing is important?
What are the steps need to be taken while testing stored procedures?
Define join and name different type of joins?
Mention different types of joins?
How does qtp evaluate test results?
Does qtp support sql queries, how to use sql queries in qtp?
What are joins?
How to test database in manually? Explain with an example?
What does the rdbms stand for and what are the major rdbms used by sql?
What is difference between having clause and where clause?
Can you test database manually, if yes; then how, explain with example?