← Deutsche Bank questions

Left Outer Join Output and Row Count

Filed under Deutsche Bank

The question

Given a department table with 3 rows (ids 1,2,3) and an employee table with 40 rows (20 rows each for dept ids 1 and 2), determine what a left outer join query returns and the exact output row count.

No write-up yet. Related questions below have one.

Related Deutsche Bank questions

Collected from public candidate posts and coding forums. Updated Nov 2026.