Reuse calculated column in a select statement

Question

Post reply

Reuse calculated column in a select statement

chibyboy

Old Hand

Points: 334
More actions
September 19, 2003 at 11:37 pm

#82261
Hi fellow developers,
I have a T-SQL question. Is it possible to write a query in such a way that a calculated column can be reused in a subsequent column below in a select statement? For example:
```
SELECT (1 + 2) AS [first], 

(3 + 4) AS [second],

[first] + [second] AS [total]
```
Of course, the above example would give me an invalid column name error. How can I reuse the [first] column and the [second] column for the [total] without having to do a
```
1 + 2 + 3 + 4
```
recalculation.
Thanks a lot for you help.
Chiby

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sachin Dedhia SSCrazy Points: 2104 More actions · Answer 1

Hi Chiby,

How about trying something like this...

SELECT [first], [second], [first] + [second] AS [Total]

FROM ( SELECT (1 + 2) AS [first], (3 + 4) AS [second]) AS NewTbl

HTH...

Sachin

Regards,
Sachin Dedhia

chibyboy Old Hand Points: 334 More actions · Answer 2

Thanks a lot Sachin

That works!

I also found out another way of doing this:



DECLARE @First INT

DECLARE @Second INT



SELECT @First = 1 + 2,

@Second = 3 + 4

 

SELECT @First AS [First], 

@Second AS [Second],

@First + @Second AS [Total]

Thanks a lot again, I really appreciate it.

Chiby

quote:
Hi Chiby,
How about trying something like this...
SELECT [first], [second], [first] + [second] AS [Total]
FROM ( SELECT (1 + 2) AS [first], (3 + 4) AS [second]) AS NewTbl
HTH...
Sachin

Sachin Dedhia SSCrazy Points: 2104 More actions · Answer 3

There is always another way...

🙂

Regards,
Sachin Dedhia