An if statement within the colums selection part of a select statement 2

[Logmaster]

Hi,

I am trying the write a query which will include 2 columns from a table and an additional calculation which will be based on the 2 first columns. If the 2nd column is more than two times bigger than the first column, return he 2nd column multiplied by 2, otherwise, return the 2nd column multiplied by 1.5. Does anyone know how to do something like that?

select column1,column2, If (column1>column2*2) column2*2 else column2*1.5
from table 1

Regards,
Joe

 

[SQLDenis]

lookup CASE in BOL

select column1,column2, 
case when column1 > (column2*2) then column2*2 else  column2*1.5 end
from table 1

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[gmmastros]

[COLOR=blue]select[/color] column1,column2, 
       [COLOR=blue]Case[/color] [COLOR=blue]When[/color] column1>column2*2
            [COLOR=blue]Then[/color] column2*2 
            [COLOR=blue]else[/color] column2*1.5
            [COLOR=blue]End[/color] [COLOR=blue]As[/color] [SomeColumnAlias]
[COLOR=blue]from[/color] table1

-George

"the screen with the little boxes in the window." - Moron

 

[Logmaster]

WOW, THAT WAS FAST.

GUYS, YOU ARE AWESOME!!!

 

[ESquared]

Logmaster,

This forum is designed to reward people who help by others awarding purple stars to them. Click on the links above, "Thank xxxxx for this valuable post!" to do that.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[Logmaster]

Hi,

I did click on the "Thank SQLDenis
for this valuable post!" and " Thank ESquared
for this valuable post!" right before I posed my last reply. I am going to do it again however if it doesn't show up this time, there is something wrong.

 

[Logmaster]

My mistake, I forgot to click on the confirmation link...

 

[ESquared]

I don't need any stars... thank you though

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]