← Morgan Stanley questions
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.