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