SQL IF ELSE STATEMENT

Question

1. SELECT ORDER
FROM ORDERLIST
WHERE IsCompleted='Y'

2. SELECT ORDER
FROM ORDERLIST
WHERE IsCompleted='N'

THEN THE OUTPUT IS 'NULL'

I would like to integrate this two logic, but I don't know how to make the code work. Please help me!

take a look at this one http://stackoverflow.com/questions/15265874/case-statement-in-mysql — JanLeeYu, Jul 08 '16 at 05:19
`order` should be placed inside backticks \`order\` or better just avoid using reserved keywords. — JanLeeYu, Jul 08 '16 at 05:33

Sankar · Accepted Answer · 2016-07-08T08:16:35.747

2

Try this...

You can use CASE WHEN Expression

SELECT 
    CASE
        WHEN IsCompleted='Y' 
        THEN
            [ORDER]
        ELSE WHEN IsCompleted='N' 
        THEN
           NULL
    END 
FROM 
    ORDERLIST

edited Jul 08 '16 at 08:16

answered Jul 08 '16 at 03:57

Sankar

6,908
2
30
53

Case expression, not statement. – jarlh Jul 08 '16 at 06:04
1

Much better! (A case expression returns a value. A case statement is just conditional execution of code, for example in a stored procedure.) – jarlh Jul 08 '16 at 06:32

score 0 · Answer 2 · answered Jul 08 '16 at 07:24

0

'Intergrate' as in UNION?:

SELECT ORDER
FROM ORDERLIST
WHERE IsCompleted='Y'
UNION
SELECT NULL
FROM ORDERLIST
WHERE IsCompleted='N'

answered Jul 08 '16 at 07:24

onedaywhen

55,269
12
100
138

score 0 · Answer 3 · answered Jul 21 '17 at 16:20

0

Try this out, this should allow you to get all the results in one table.

    SELECT ORDER
    FROM ORDERLIST
    WHERE IsCompleted = 'Y' OR IsCompleted = 'N'

answered Jul 21 '17 at 16:20

Alex Cantrell

1
1

SQL IF ELSE STATEMENT

3 Answers3