Oracle-L: SQL Question

From: Iraida Becerra <ICBHC_at_CUNYVM.BITNET>
Date: Wed, 10 Jan 1996 16:00:57 EST
Message-Id: <9601102153.AA12449@alice.jcc.com>

Let's say I have a table with two columns: dept#, and number of employees in each department. The table looks as follow: Dept# Number of Employees

10     60
20     70
30     80

I would like to create a query that returns the percentage the number of employees in each department represents of the total number of employees. The result will look like: Dept# %

10     28.57
20     33.33
30     38.09

Any help would be appreciated.
Thx. Iraida Received on Wed Jan 10 1996 - 16:53:11 CST