Calculate percentage for each row

[smileyangeluv]

Hi,

Would like to get percentage for generated column. Any idea on how to do that??

Following SQL statement

SELECT s.Selection_Desc, count(u.user_id)
from tbl_system_selection s, tbl_user u, tbl_user_company c
where s.selection_type = 'INDUSTRY'
and u.User_Company_ID = c.Company_ID 
and c.Company_Industry_ID = s.Selection_ID 
and u.user_activated = '1'
group by s.selection_id

gives the result of

======================================

Selection_desc  count(u.user_id)
 
Marketing         44
Sales               54
Finance           100

=======================================

i would like to get percentage for each row

for example Finance shd give 50% (100/(45+55+100))*100)

======================================

Selection_desc  count(u.user_id)  perc
 
Marketing         45                       22.5
Sales               55                       27.5
Finance           100                      50

=====================================

[Atli]

Hi.

This is something I would do using a external API, like PHP. It would be much simpler than doing it via the MySQL query, if it is even possible.

If this has to be done via MySQL I would suggest using a stored procedure.

[smileyangeluv]

is there any way, for example, like nested query?

[amitpatel66]

is there any way, for example, like nested query?

select mgr, COUNT(mgr),((count(mgr)/(SELECT COUNT(*) from emp)) * 100) from emp where mgr IS NOT NULL group by mgr
 

The above query gives me the % for the no of employees unser a particular manager. try applying this logic to your query for finding the %

I hope this helps!!