我是这样写的,不知道哪里错了
USE YGGL
GO
SELECT EmployeeID,Name,Address,DepartmentID=
(
IF (SELECT DepartmentID FROM Employees)='1' BEGIN RETURN '财务部' END
IF (SELECT DepartmentID FROM Employees)='2' BEGIN RETURN '人力资源部' END
IF (SELECT DepartmentID FROM Employees)='3' BEGIN RETURN '经理办公室' END
IF (SELECT DepartmentID FROM Employees)='4' BEGIN RETURN '研发部' END
IF (SELECT DepartmentID FROM Employees)='5' BEGIN RETURN '市场部' END
)
FROM Employees
使用CASE对Employees表按部门进行分类:
USE YGGL
GO
SELECT EmployeeID ,Name,Address,DepartmentID=
CASE DepartmentID
WHEN 1 THEN ‘财务部’
WHEN 2 THEN ‘人力资源部’
WHEN 3 THEN ‘金理办公室’
WHEN 4 THEN ‘研发部’
WHEN 5 THEN ‘市场部’
END
FROM Employees
练习: 使用IF语句实现上述功能