[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