EmployeeDatabaseQuery
Topsolutions (Not rated)
(Not rated)
sql here is the scenerio:
scenerio 1
Table 1 Employee (emp id, emp name)
table 2 department (dept id, dept Name)
table 3 Mapping (emp id, dept id)
1 Using joins write a query to fetch list of employees that belong to "healthcare department"
2 withou using joins-write a querry to fetch list of employees the belong to healthcare department
scenerio 2 Now add emp salary to scenario 1
write a sql to fetch the of employee that has 2nd highest salary
- 9 years ago
Complete A++ Solution
NOT RATED
Purchase the answer to view it
- employeedatabasequery.docx