阅读背景:

在SQL Server的where子句中传递多个值

来源:互联网 
SELECT
     "dbo"."ClaimDataFormat"."AGE",
     "dbo"."ClaimDataFormat"."RELATION",
     "dbo"."ClaimDataFormat"."NAME",
     "dbo"."ClaimDataFormat"."ENTRY_DATE",
     "dbo"."ClaimDataFormat"."CLAIM_AMT",
     CASE
     WHEN "dbo"."ClaimDataFormat"."Gender" = 'F'
     THEN 'FEMALE'
     ELSE 'MALE'
     END AS GENDER,
     "dbo"."ClaimDataFormat"."STATUS",
     "dbo"."ClaimDataFormat"."APPROVED_AMT"
FROM
     "dbo"."ClaimDataFormat"
WHERE "dbo"."ClaimDataFormat"."AGE" = CASE 
                          WHEN ${TimeGran} = '0-10' 
                               THEN 0 
                          WHEN ${TimeGran} = '0-10'
                               THEN 1
                     WHEN ${TimeGran} = '0-10'
                               THEN 2
                          WHEN ${TimeGran} = '0-10'
                               THEN 3
                          WHEN ${TimeGran} = '0-10'
                               THEN 4
                          WHEN ${TimeGran} = '0-10'
                               THEN 5  
                          WHEN ${TimeGran} = '0-10'
                               THEN 6
                          WHEN ${TimeGran} = '0-10'
                               THEN 7
                          WHEN ${TimeGran} = '0-10'
                               THEN 8
                          WHEN ${TimeGran} = '0-10'
                               THEN 9
                          WHEN ${TimeGran} = '0-10'
                               THEN 10
                          WHEN ${TimeGran} = '11-20'
                               THEN 11 
                          WHEN ${TimeGran} = '11-20'
                               THEN 12
                          WHEN ${TimeGran} = '11-20'
                               THEN 13
                     WHEN ${TimeGran} = '11-20'
                               THEN 14
                          WHEN ${TimeGran} = '11-20'
                               THEN 15
                          WHEN ${TimeGran} = '11-20'
                               THEN 16
                          WHEN ${TimeGran} = '11-20'
                               THEN 17  
                          WHEN ${TimeGran} = '11-20'
                               THEN 18
                          WHEN ${TimeGran} = '11-20'
                               THEN 19
                          WHEN ${TimeGran} = '11-20'
                               THEN 20

                          ELSE 21
                     END 
SELECT
     "dbo"."ClaimDataFormat"."AGE",
    



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: