OraFAQ Forum: SQL & PL/SQL » who is expert in sql\plsql

Home » SQL & PL/SQL » SQL & PL/SQL » who is expert in sql\plsql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

who is expert in sql\plsql [message #20818]

Sun, 23 June 2002 19:06

jawadg
Messages: 19
Registered: May 2002

Junior Member

i want to print highest percentage of sal column from emp table
plz. help

Report message to a moderator

Re: who is expert in sql\plsql [message #20827 is a reply to message #20818]

Mon, 24 June 2002 03:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> ED
Wrote file afiedt.buf

1 select deptno, sum(sal), round( sum(sal)/tot_sal*100, 2 ) || ' %'
2 from emp, ( select sum(sal) tot_sal from emp )
3* group by deptno, tot_sal
SQL> /

DEPTNO SUM(SAL) ROUND(SUM(SAL)/TOT_SAL*100,2)||'%'
---------- ---------- ------------------------------------------
10 8750 30.15 %
20 10875 37.47 %
30 9400 32.39 %

Report message to a moderator

Re: who is expert in sql\plsql [message #20831 is a reply to message #20818]

Mon, 24 June 2002 08:28

sridhar
Messages: 119
Registered: December 2001

Senior Member

select round(max(sal)/sum(sal) * 100, 2) max_percent from emp;

thx,
Sri

Report message to a moderator

Previous Topic:	urgent - getting in month and upto month figures in the same query
Next Topic:	recent change from sqlserver to oracle8i, i don't know the passwords

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 01:36:07 CDT 2024