reg small query help
user586Mar 9 2007 — edited Apr 14 2009i 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