數據庫的查詢和視圖(參考版)
2025-06-29 20:55本頁面
【正文】 139。02001039。王浩39。539。生產車間39。廣告業(yè)務39。廣告部39。639。朱俊39。339。 )5).查詢結果分組和排序(1).查找Employees表中男性和女性的人數代碼：SELECT Sex,COUNT(Sex) FROM Employees GROUP BY Sex。 ) )(3).求財務部雇員的總人數代碼：SELECT COUNT(EmployeeID) FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。 FROM Salary WHERE ID IN ( SELECT EmployeeID FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。 ) )(2).求財務部雇員的平均實際收入代碼：SELECT AVG(IneExpense)AS39。 FROM Salary WHERE ID IN ( SELECT EmployeeID FROM Employees WHERE DepartmentID= ( SELECT DepartmentID FROM Departments WHERE DepartmentName=39。 AND Ine20004).使用聚合函數查詢(1).求財務部雇員的平均收入代碼：SELECT AVG(Ine)AS39。(3) .查找財務部收入在2000元以上的雇員明明及其薪水詳情代碼：SELECT Name,Ine,Expense FROM Employees,Salary,Departments WHERE = AND = AND DepartmentName=39。 ) ) ) )3).連接查詢(1).查詢每個雇員的情況及其薪水情況代碼：USE YGGLGOSELECT Employees.*,Salary.* FROM Employees,Salary WHERE =(2).使用內連接的方法查詢名字為“王林”的員工所在的部門代碼：SELECT DepartmentName FROM Departments JOIN Employees ON = WHERE =39。 ))(3).查找比所有財務部的雇員收入都高的雇員的姓名代碼：SELECT Name FROM Employees WHERE EmployeeID IN (
規(guī)章制度相關推薦
鄂ICP備17016276號-1