How is INNER JOIN different from simply writing a JOIN?

1.	How is INNER JOIN different from simply writing a JOIN?
Answer» If we do not specify the type of join, by default, the join is an INNER JOIN. So, there is no difference between writing INNER JOIN or simply writing JOIN. Now that we have SEEN some of the most POPULAR interview questions of DB2 for freshers, LET US move to some intermediate and advanced questions too that are asked in the INTERVIEWS from an experienced candidate.

Answer»

If we do not specify the type of join, by default, the join is an INNER JOIN. So, there is no difference between writing INNER JOIN or simply writing JOIN.

Now that we have SEEN some of the most POPULAR interview questions of DB2 for freshers, LET US move to some intermediate and advanced questions too that are asked in the INTERVIEWS from an experienced candidate.

Discussion

No Comment Found

Related InterviewSolutions

How is INNER JOIN different from simply writing a JOIN?
What is DCLGEN in DB2?
As you know there are different sizes of locks. Can you tell how DB2 decides which lock size should be used?
What are the two levels of isolation and what is the major difference between the 2 levels?
How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?
What is MAX in DB2? Is it possible to use MAX in a CHAR column?
What is a CURSOR and What is the use of it?
What is concurrency in terms of DB2?
What are UNION and UNION ALL in DB2? How do you differentiate between them?
What is the difference between the above two queries i.e. DELETE and DROP?

How is INNER JOIN different from simply writing a JOIN?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment