CODEWITHSUNDEEP
sqlselect
RJIGO
RJIGO

Reputation: 1943

How to do an IF calculation in SQL Select?

My select statement starts as follows:

select Number, Number*2 as NumberTimes2 from Table1 ...

If I want NumberTimes2 to be 100 when Number*2 >= 100, how do I code this in the select statement? Thanks.

Upvotes: 0

Views: 5242

Answers (1)

Bohemian
Bohemian

Reputation: 425063

select
  Number,
  case when Number > 50 then 100 else Number * 2 end as NumberTimes2
from Table1
...

All flavours of SQL allow a CASE statement (you haven't stated which database you are using). Depending on your database, you may be able to do it in a briefer way (for example mysql's if statement)

Upvotes: 6

Related Questions