given 2 table and explain o/p a(1,1,1,2,3) b(1,1,3,4,5) innner join left and right and cross join

Question

Accepted Answer

Explanation of inner join, left join, right join, and cross join with given tables a and b.

Inner join: Returns only the rows where there is a match in both tables based on the specified condition.
Left join: Returns all rows from the left table and the matched rows from the right table. If there is no match, NULL values are returned.
Right join: Returns all rows from the right table and the matched rows from the left table. If there is no match, NULL values are returned.
Cross join: Returns the Cartesian product of the two tables, i.e., all possible combinations of rows from both tables.
Example: Inner join of tables a and b on column 1 would return (1,1,1,1) as the output.
Example: Left join of tables a and b on column 1 would return (1,1,1,1), (1,1,1,3), (1,1,1,4), (1,1,1,5), (1,1,2,NULL), (1,1,3,NULL).
Example: Right join of tables a and b on column 1 would return (1,1,1,1), (1,1,1,3), (1,1,1,4), (1,1,1,5), (1,1,3,NULL).
Example: Cross join of tables a and b would return (1,1,1,1), (1,1,1,1), (1,1,1,3), (1,1,1,4), (1,1,1,5), (1,1,2,1), (1,1,2,1), (1,1,2,3), (1,1,2,4), (1,1,2,5), (1,1,3,1), (1,1,3,1), (1,1,3,3), (1,1,3,4), (1,1,3,5).

Top Synechron SQL and PL SQL Developer interview questions & answers