數(shù)據(jù)庫的查詢和視圖(編輯修改稿)
2025-07-23 20:55 本頁面
【文章內(nèi)容簡介】 ( SELECT InCome FROM Salary WHERE EmployeeID IN ( SELECT EmployeeID FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。財(cái)務(wù)部39。 ) ) ) )3).連接查詢(1).查詢每個(gè)雇員的情況及其薪水情況代碼：USE YGGLGOSELECT Employees.*,Salary.* FROM Employees,Salary WHERE =(2).使用內(nèi)連接的方法查詢名字為“王林”的員工所在的部門代碼：SELECT DepartmentName FROM Departments JOIN Employees ON = WHERE =39。王林39。(3) .查找財(cái)務(wù)部收入在2000元以上的雇員明明及其薪水詳情代碼：SELECT Name,Ine,Expense FROM Employees,Salary,Departments WHERE = AND = AND DepartmentName=39。財(cái)務(wù)部39。 AND Ine20004).使用聚合函數(shù)查詢(1).求財(cái)務(wù)部雇員的平均收入代碼：SELECT AVG(Ine)AS39。財(cái)務(wù)部平均收入39。 FROM Salary WHERE ID IN ( SELECT EmployeeID FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。財(cái)務(wù)部39。 ) )(2).求財(cái)務(wù)部雇員的平均實(shí)際收入代碼：SELECT AVG(IneExpense)AS39。財(cái)務(wù)部平均實(shí)際收入39。 FROM Salary WHERE ID IN ( SELECT EmployeeID FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。財(cái)務(wù)部39。 )
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號(hào)-1