SQL CASE with more than one condition

Question

SQL CASE with more than one condition

Navigation

#1 by (2 votes)
#2 by (0 votes)
#3 by (0 votes)

1

I wonder if you can use CASE with more than 1 condition.

In this query I have calculations that need to be done when a.operacao == 'C' but that depend on the value of a.DESCRICAO_PREMIO ( '1P' or '1/5P' ) to define which account exactly.

SELECT
  a.*,
  CASE (a.operacao)
    WHEN 'C' THEN  (b.multiplicador *  a.valor_jogo)
  END AS [Valor]
FROM tb_jogo_detalhe a
  INNER JOIN tb_modalidade b ON b.abreviatura = a.operacao
WHERE a.ID = 2222

How to use more than one condition in a CASE ?

sql sql-server

asked by anonymous 08.05.2016 / 22:13

3 answers

Jquery - click button to do list show and button hide? Bit array in c doubt

score 2 · Answer 1

Yes, it does. Look:

select  a.*,                                                           
           case
               when a.operacao = 'C' and a.DESCRICAO_PREMIO = '1P' then  (b.multiplicador *  a.VALOR_JOGO)
               when a.operacao = 'C' and a.DESCRICAO_PREMIO = '1/5P'then  (/** coloca o outro calculo aqui e vai indo**/)
           end as valor                                            
           from dbo.TB_JOGO_DETALHE a                                                                               
           inner join tb_modalidade b on b.abreviatura = a.operacao  
           where a.ID = 2222

score 0 · Answer 2

Get it done this way!

           select  a.*,                                                           
           case 
            when (a.operacao = 'C' and a.DESCRICAO_PREMIO = '1P')  then  (b.multiplicador *  a.VALOR_JOGO) 
            when (a.operacao = 'C' and a.DESCRICAO_PREMIO = '1/5P ')  then  ( (b.multiplicador / 5) *  a.VALOR_JOGO)                           
           END AS VALOR_PREMIO 
           from TB_JOGO_DETALHE a                                                                               
           inner join tb_modalidade b on b.abreviatura = a.operacao  
           where a.IDJOGO = 70

score 0 · Answer 3

0

Yes does follow the basic syntax for using Case

select case when ((condição1) and (condicao2) and (condicao3))
            then 'Verdadeiro'
            else 'Falso'
       end
  from Tabela

09.05.2016 / 23:07