sql basic if else conditions

Question

I have this table:

|car |house|
|2010|2012 |
|2005|2004 |
|2003|2003 |
|2006| |

and I need to create this table from it:

|car |house|result|
|2010|2012 |after |
|2005|2004 |before|
|2003|2003 |after |
|2006| |x |

cases:
car<house result=before
car>house result=after
car=house result=after
house is empty -> result=x

sagi · Accepted Answer · 2016-07-10 14:42:21Z

3

Use CASE EXPRESSION :

SELECT t.car,t.house,
       CASE WHEN t.house >= t.car THEN 'AFTER'
            WHEN t.house < t.car THEN 'BEFORE'
            ELSE 'x'
       END as result
FROM YourTable t

EDIT: To join this to another table :

SELECT * FROM (
    SELECT t.car,t.house,
           CASE WHEN t.house >= t.car THEN 'AFTER'
                WHEN t.house < t.car THEN 'BEFORE'
                ELSE 'x'
           END as result
    FROM YourTable t) s
JOIN Another_Table tt
 ON(s.result = tt.Column)

edited Jul 10, 2016 at 14:42

answered Jul 10, 2016 at 13:41

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hanznv Over a year ago

with this code I get only data output with this new column(result), but how can I join this column in to t. table ? thank you

Collectives™ on Stack Overflow

sql basic if else conditions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related