Written By:- Isha Malhotra (Software Developer)
Email:-malhotra.isha3388@gmail.com.
Note: -if you find this article helpful then kindly leave your comment
For Asp.net Training with C# and Sql Server Click Here
Nested or Sub
Queries practice questions
Following is the Employee Table which contains the detail
for the employee with department id and head id. Head of the employee is also
an another employee
Table:-Employee
EmpId
|
EmpName
|
Department
|
ContactNo
|
EmailId
|
EmpHeadId
|
101
|
Isha
|
E-101
|
1234567890
|
abc@gmail.com
|
105
|
102
|
Priya
|
E-104
|
1234567890
|
abc@gmail.com
|
103
|
103
|
Neha
|
E-101
|
1234567890
|
abc@gmail.com
|
101
|
104
|
Rahul
|
E-102
|
1234567890
|
abc@gmail.com
|
105
|
105
|
abhishek
|
E-101
|
1234567890
|
abc@gmail.com
|
102
|
