[条件控制] SQL条件控制（case....when....then...else...end 语法）

SELECT 

      [SlUser].[Username] AS UserName 
     ,[RealName]
     ,(case when [Type]=0 then '未通过验证' when [Type]=1 then '免费接口验证' else '收费接口验证'end) as 认证类型       
     ,(case when [SlUserIdCardVerify].[State]=0 then '未通过' else '通过'end) as 认证状态
     ,[VerifyDate]
     ,[SlUserIdCardVerify].[Title]
     ,[SlCity].[Name]        
     ,[SlUser].[MobilePhone] AS MobilePhone
 
FROM [SlUserIdCardVerify] WITH (NOLOCK)
JOIN [SlCity] WITH (NOLOCK) ON [SlCity].[ID] = [SlUserIdCardVerify].[CityID]
LEFT JOIN [SlUser] WITH (NOLOCK) ON [SlUser].[ID] = [SlUserIdCardVerify].[UserID]

结果显示：