CODEWITHSUNDEEP
subqueryhanasql-scripts
Gustavo Alexander Carrillo Rue
Gustavo Alexander Carrillo Rue

Reputation: 143

How can I store the value of a subquery into a variable in Hana Studio?

I would like to know how can I store the value of subquery to use it in an operation after it recieve the value. For example:

Select IDTruck
, TruckPrice = (select "TruckPrice" from "Table1"  where  ("TruckID" = '123'))

, TruckUnit = (select "TruckUnit" from "Table2" )

, TruckPrice * TruckUnit as "PriceTotal"
from Table3

I just want to store the value and then use it in the operation so I don't have to do the select again.

Upvotes: 0

Views: 318

Answers (1)

Florian Pfeffer
Florian Pfeffer

Reputation: 269

I'm not sure why it should be necessary to store the values in variables for usage in your case. I think the calculation can be done also by joining just the data (assuming that table3 contains a reference to table1 and table2).

Your example above would also not work, because TruckPrice and TruckUnits are no atomar results.

So please try to refactor your statement to use joins.

Upvotes: 1

Related Questions