[Solved] Find column Value by dividing with sum of a column
You can use SUM with the OVER Clause . select Id, field1, (sum(field1) over() / field1) as field2 from YourTable SQLFiddle 2 solved Find column Value by dividing with sum of a column
You can use SUM with the OVER Clause . select Id, field1, (sum(field1) over() / field1) as field2 from YourTable SQLFiddle 2 solved Find column Value by dividing with sum of a column