简单的T-SQL查询

Question

从上述采样数据，我想要写的查询将返回SalesAmount两个为0.0如果ExpRow值= 1，并返回ExpenseAmount为0.0如果ExpRow值= 2

Answer 1

不知道这是否正是你在之后但是...

SELECT CASE([ExpRow]) WHEN 1 THEN 0 ELSE SalesAmount END AS 'SalesAmount', 
     CASE([ExpRow]) WHEN 2 THEN 0 ELSE ExpenseAmount END AS 'ExpenseAmount' 
FROM [YOUR_TABLE] 

Answer 2

SELECT 
    ExpRow, 
    ExpenseDate, 
    CASE WHEN ExpRow = 2 THEN 0 ELSE ExpenseAmount END AS ExpenseAmount, 
    CASE WHEN ExpRow = 1 THEN 0 ELSE SalesAmount END AS SalesAmount 
FROM 
    Table