IF, ELSE statement for sql query

Question

How to write a SQL query where I have a table called ACC_REQUEST?

There is a column in the table called REQUEST_STATUS with the values of 'pending', 'withdrawn', and 'completed

If the request status value = 'pending then select approver_name from ACC_APPROVAL, else select request status

dudeman · Accepted Answer · 2015-03-04 01:31:47Z

1

You can use CASE

Like:

CASE x WHEN bah THEN FOO END CASE

http://dev.mysql.com/doc/refman/5.0/en/case.html

answered Mar 4, 2015 at 1:31

dudeman

6034 silver badges11 bronze badges

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

Comments

DWright · Accepted Answer · 2015-03-04 01:34:00Z

1

Something like

SELECT 
    CASE
        WHEN ACC_REQUEST.REQUEST_STATUS = 'pending' THEN ACC_APPROVAL.APPROVER_NAME
        ELSE ACC_REQUEST.REQUEST_STATUS
    END as [put the name you wish for output column here, no square brackets]
FROM ACC_REQUEST
INNER JOIN ACC_APPROVAL ON [I'm assuming some kind of join condition here]

answered Mar 4, 2015 at 1:34

DWright

9,5594 gold badges39 silver badges57 bronze badges

1 Comment

dudeman Over a year ago

better answer then mine ;)

Collectives™ on Stack Overflow

IF, ELSE statement for sql query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related