sql 面经 求助 谢谢# JobHunting - 待字闺中
d*f
1 楼
1. A table schema with tables like employee, department, employee_to_
department, project, employee_to_project
1) Select employee from departments where max salary of the department is
40k
2) Select employee assigned to projects
3) Select employee which have the max salary in a given department
4) Select employee with second highest salary
2. Table has two data entries every day for number of apples and oranges
sold. write a query to get the difference between the apples…
department, project, employee_to_project
1) Select employee from departments where max salary of the department is
40k
2) Select employee assigned to projects
3) Select employee which have the max salary in a given department
4) Select employee with second highest salary
2. Table has two data entries every day for number of apples and oranges
sold. write a query to get the difference between the apples…