Hello all,
Would like to query with concept shown below, but keep getting syntax errors -
select col_1 as this, col_2 as that, (this * that) as answer , sum(answer) from table_name. I have tried multiple variations of this, to no avail - simply I would like to select a record of col_1, and a record of col_2, multiply the two together, then sum the result as the query moves through the table...thoughts?
Thanks everyone.
Would like to query with concept shown below, but keep getting syntax errors -
select col_1 as this, col_2 as that, (this * that) as answer , sum(answer) from table_name. I have tried multiple variations of this, to no avail - simply I would like to select a record of col_1, and a record of col_2, multiply the two together, then sum the result as the query moves through the table...thoughts?
Thanks everyone.