Sql use calculated field in where clause

Comments and Discussions

You must Sign in to use this message board.

First Prev Next

Select * from ( Select Column1, Column2, Calculated_Column = Case When Expression1 = True Then Column1 * (Column4 - Column 5) When Expression2 = True Then Column2 * (Column5 - Column 6) When Expression3 = True Then Column3 * (Column6 - Column 7) Else Column4 - Column 5 End From Table ) T Where Calculated_Column < 100

martin.fay 16-Jun-13 22:26

Peni 13-Jun-13 21:39

Last Visit: 31-Dec-99 18:00 Last Update: 4-Sep-24 2:38

Refresh

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Posted 13 Jun 2013