实践参照:
Select
column1 AS xno,
column2 AS xntCode,
column3 AS xstCode,
column4 AS xalsCode,
(Case
When XplId = '01' Then 'prod01'
When XplId = '02' AND xTeCde != '8' Then 'prod02'
When XplId = '03' TAND xTeCde = '8' Then 'prod03'
END) As PROD
From
XDb.TableName
Where
codintion
OrderBy
XXX
With CS