Using calculated fields over and over again with a new table
- by Sin5k4
I'm fairly new to SQL and i had to do some calculations using a table.Imagine we have a table with fields : ID - Name - Val1 - Val2 ; Lets say i want to add up 2 values and add it to my query result.I can do that easily with a sub query such as:
select val1+val2 as valtotal,* from my table.
Now if i want to do some more process on valtotal, i use a derived table such as;
select valtotal*3 as ValMoreCalculated,* from
(select val1+val2 as valtotal,* from my table) AS A
A bit more code maybe??
select ValMoreCalculated/valtotal as ValEvenMoreCalc ,* from
(select valtotal*3 as ValMoreCalculated,* from
(select val1+val2 as valtotal,* from my table) AS A)AS B
So if i want to do more calculations with the ValMoreCalculated do i have to go through another derived table? Name it as B for example? Is there an easier way to achieve this in SQL?
PS:the title is a bit off i know,but couldn't figure out what to name it :P
