What is the expected output of below SQL
SELECT dt.DeptNo FROM dept_tbl dt LEFT OUTER JOIN dept_master dm ON dt.DeptNo = dm.DeptNo;
Table Dept _tbl
Dept No
Depart Name
10
Accounting
20
Purchase
30
Sales
50
Marketing

Table Dept_master
DeptNo
DepartName
10
Accounting
20
Purchase
30
Sales
40
Stores

Question

What is the expected output of below SQL

SELECT dt.DeptNo FROM dept_tbl dt LEFT OUTER JOIN dept_master dm ON dt.DeptNo = dm.DeptNo;

Table Dept _tbl

Table Dept_master

anonymous · Accepted Answer

Correct Solution - d

What is the expected output of below SQL SELECT dt.DeptNo FROM dept_tbl dt LEFT OUTER JOIN dept_master dm ON dt.DeptNo = dm.DeptNo; Table Dept _tbl Dept No Depart Name10 Accounting 20 Purchase 30 Sales 50 Marketing Table Dept_masterDeptNoDepartName10 Accounting 20 Purchase30 Sales 40 Stores