If two table have 5 and 3 entry and we apply inner join then what will be the maximum and minimum number of entry possible in final result

Question

Accepted Answer

Inner join of two tables with 5 and 3 entries can result in a minimum of 0 and a maximum of 3 entries.

Inner join returns only the matching rows from both tables.
The maximum number of entries in the result will be equal to the number of matching rows.
If there are no matching rows, the result will have 0 entries.
In this case, the maximum number of entries will be 3, as there can be at most 3 matching rows.

Accepted Answer

The number of entries in the final result of an inner join depends on the matching rows in the two tables. If the two tables have 5 and 3 entries respectively, the maximum number of entries in the final result will be the number of matching rows between the two tables, which could be a maximum of 3 entries (if all the rows in both tables have matching values on the specified column).

The minimum number of entries in the final result will be 0 if there are no matching rows between the two tables. In other words, if there is no common value in the specified column of the two tables, the inner join will result in an empty table.

So, the final result of an inner join between two tables with 5 and 3 entries respectively could have between 0 and 3 entries, depending on the matching rows between the two tables.

If two table have 5 and 3 entry and we apply inner join then what will be the maximum and minimum number of entry possible in final result

Top Razorpay Associate Analytics interview questions & answers

Popular interview questions of Associate Analytics

Top HR questions asked in Razorpay Associate Analytics