Breaking News: Grepper is joining You.com. Read the official announcement!

Nest Case statement in SQL

SIDANTH R answered on September 21, 2022 Popularity 7/10 Helpfulness 5/10

answer Nest Case statement in SQL

related Nest Case statement in SQL

Nest Case statement in SQL

Comment

Select
case
    when a=1 then
        case 
            when b=0 then 'True'
            when b=1 then 'Trueish'
        end
    When a=0 then
        case
            when b=0 then 'False'
            when b=1 then 'Falseish'
        end
    else null
end AS Result
FROM tablename

Popularity 7/10 Helpfulness 5/10 Language sql

Source: dba.stackexchange.com

Tags: case-statement nest sql

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

SIDANTH R

0 Answers Avg Quality 2/10

Closely Related Answers

Nest Case statement in SQL

Comment

Select 
case 
    when a=1 and b=0 THEN 'True'
    when a=1 and b=1 then 'Trueish'
    when a=0 and b=0 then 'False'
    when a=0 and b=1 then 'Falseish'
    else null
end AS Result
FROM tableName

Popularity 6/10 Helpfulness 2/10 Language sql

Source: dba.stackexchange.com

Tags: sql case-statement nest case-st

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

SIDANTH R

0 Answers Avg Quality 2/10

Nest Case statement in SQL

Comment

Select 
case 
    when a=1 and b=0 THEN 'True'
    when a=1 and b=1 then 'Trueish'
    when a=0 and b=0 then 'False'
    when a=0 and b=1 then 'Falseish'
    else null
end AS Result
FROM tableName

Popularity 7/10 Helpfulness 1/10 Language sql

Source: dba.stackexchange.com

Tags: sql nest case-statement case-sta

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

SIDANTH R

0 Answers Avg Quality 2/10

Nest Case statement in SQL

Comment

Select 
case 
    when a=1 and b=0 THEN 'True'
    when a=1 and b=1 then 'Trueish'
    when a=0 and b=0 then 'False'
    when a=0 and b=1 then 'Falseish'
    else null
end AS Result
FROM tableName

Popularity 7/10 Helpfulness 1/10 Language sql

Source: dba.stackexchange.com

Tags: sql nest case-statement ca

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

SIDANTH R

0 Answers Avg Quality 2/10

Nest Case statement in SQL

Contents

More Related Answers

Nest Case statement in SQL

Closely Related Answers

Nest Case statement in SQL

Nest Case statement in SQL

Nest Case statement in SQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.