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

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

anonymous · Accepted Answer

The SQL query is like a matching game! Its looking for department numbers (DeptNo) in both tables, dept_tbl and dept_master. It will show all the department numbers from dept_tbl, even if theres no match in dept_master. So, the final answer is: 10, 20, 30, and 50! All the department numbers from dept_tbl are shown, no matter what!

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

Important Links

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