Low-Level DesignReported in a candidate post, Jul 2025
Row counts for various SQL table joins
Filed under Morgan Stanley
The question
Consider two tables A and B with an 'id' column, and determine the number of rows present in the final output for inner join, left join, right join, and full outer join.
No write-up yet. Related questions below have one.
Related Morgan Stanley questions
Collected from public candidate posts and coding forums. Updated Nov 2026.