Details of this Paper

EmployeeDatabaseQuery

Description

solution


Question

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

 

Paper#64762 | Written in 18-Jul-2015

Price : $27
SiteLock