SQL Server使用教程课后的实验数据库yggl

e), 最低收入=MIN(e-e) from Employees,Departments,Salary where Employees.DepartmentID=Departments.DepartmentID and Employees.EmployeeID=Salary.EmployeeID and DepartmentName=' 财务部' go -- 找出所有姓王的雇员的部门号 select DepartmentID from Employees where Name like '王%' go -- 找出所有其地址中包含有“中山”的雇员的号码及部门号 select PhoneNumber,DepartmentID from Employees where Address like '% 中山%' go select * from Employees go -- 找出员工号码中倒数第二个数学为 0 的员工的姓名、地址和学历 select Name,Address,Education from Employees where EmployeeID like '%0_' go select * from Employees go -- 查找所有收入在 2000~3000 元之间的员工号码 select * from Salary go select EmployeeID from Salary where e>=2000 and e<3000 --where e between 2000 and 3000 go -- 找出所有部门在“1”或“2”工作的雇员的号码 select * from Employees select * from Departments go select distinct EmployeeID from Employees,Departments