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

    blurred-text
    • attachment
      employeedatabasequery.docx