Nested Queries
Table Name:- Employee
Copyright By PowCoder代写 加微信 powcoder
Department
1234567890
1234567890
1234567890
1234567890
1234567890
Table :- EmpDept
Development
Hous Keeping
Table :- EmpSalary
IsPermanent
Table :- Project
Table :- Country
Table :- ClientTable
ClientName
tech altum
Table :- EmpProject
1. Select the department name of the company which is assigned to the employee whose employee id is grater 103.
2. Select the name of the employee who is working under Abhishek.
3. Select the name of the employee who is department head of HR.
4. Select the name of the employee head who is permanent.
5. Select the name and email of the Dept Head who is not Permanent.
6. Select the employee whose department off is monday
7. select the indian clinets details.
8. select the details of all employee working in development department.
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com