SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reg small query help

user586Mar 9 2007 — edited Apr 14 2009

i have a table like this

this is the table .

Emp_id SAL %SAL
101 10000 (10000*100/45000)
102 15000
103 20000
---------
Sum(sal) 45000
---------

We need a query to calculate the % like this i.e sal*100/sum(sal) without using group by clause.

please help me

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2009

Added on Mar 9 2007

6 comments

3,593 views