How to use if statement in SQL Query?

Question

 Select Value1,Value2,Value3 from Table1 where time > DATEADD(DAY,-2,GETDATE())

 ordery BY time desc

Result :

Value1=25

Value2=50

Value3=70

How can I change result to be

Value1=25

Value2=0 (if Value2=50 it will be 0)

Value3=70

John Woo · Accepted Answer · 2013-12-07 12:51:14Z

4

If I understand you correctly, you can use CASE statement,

SELECT Value1,
       CASE WHEN Value2 = 50 THEN 0 ELSE Value2 END Value2,
       .....

answered Dec 7, 2013 at 12:51

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

2 Comments

Mhmt Over a year ago

@ 今草顿 웃 Executing query time : 00:00:04 for using my first query. But when I used this query Executing query time : 00:01:04.Is it normal ?

JBond Over a year ago

Mehmet your query is now having to evaluate data in the column value2 to determine which value to output from the CASE statement. So it's going to require further processing, causing execution time to increase.

Collectives™ on Stack Overflow

How to use if statement in SQL Query?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related