SQL statement with if else

Question

I want the output of SQL statement based on some if else condition.

For Ex:

select salary from EMP

EMP table has a column DOJ.

Now I want the output as '-' if the DOJ is less than 90 days.

How can i do this ?

Thanks friend. I hope this will work with multiple columns in result as well. — Ritesh
– Ritesh, Commented Mar 19, 2014 at 7:02
What datatype is DOJ? Is it a date and do you want to test 90 days from now? — wumpz
– wumpz, Commented Mar 19, 2014 at 7:17

vhadalgi · Accepted Answer · 2014-03-19 07:07:04Z

2

In sql-server

 select *,case when DATEDIFF(DAY,DOJ,getdate()) <=90 then '-' else null end as mytest
    from tbale

edited Mar 19, 2014 at 7:07

answered Mar 19, 2014 at 7:01

vhadalgi

7,2376 gold badges44 silver badges67 bronze badges

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

Comments

Milen · Accepted Answer · 2014-03-19 07:46:38Z

1

SELECT CASE WHEN (DATEDIFF(DAY,DOJ,getdate()) < 90) then '-' else cast(Salary as varchar(15)) end as Salary
FROM EMP

edited Mar 19, 2014 at 7:46

answered Mar 19, 2014 at 7:04

Milen

8,8977 gold badges47 silver badges59 bronze badges

Comments

Chalky · Accepted Answer · 2014-03-19 07:05:39Z

0

select IIF ( DOJ < 90 , '-', salary ) as FormattedSalary
from EMP

answered Mar 19, 2014 at 7:05

Chalky

1,65218 silver badges21 bronze badges

1 Comment

Chalky Over a year ago

You might have to cast salary as text, I don't know the format of that column of course.

Pablo Francisco Pérez Hidalgo · Accepted Answer · 2014-03-19 07:06:15Z

0

For most of database servers you should use CASE but MySQL offers a shortcut:

SELECT IF(DOJ<90, '-', salary) FROM EMP;

edited Mar 19, 2014 at 7:06

answered Mar 19, 2014 at 7:00

Pablo Francisco Pérez Hidalgo

27.8k8 gold badges39 silver badges64 bronze badges

Collectives™ on Stack Overflow

SQL statement with if else

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related