select x.num, sum(x.num) over () as aaa , Round((x.num/sum(x.num) over ()), 2) as vv
from tableAA x
[url]http://www.akadia.com/services/ora_analytic_functions.html[/url]
[url]http://www.psoug.org/reference/analytic_functions.html[/url]
select x.num, sum(x.num) over () as aaa , Round((x.num/sum(x.num) over ()), 2) as vv
from tableAA x