Wednesday, 15 February 2012

oracle - get all columns after finding sum of Sal from a table -



oracle - get all columns after finding sum of Sal from a table -

i have 3 columns employee_id,e_name,sal , want sum of sal grouping employee_id , want columns employee_id,e_name,sal,sum out set in oracle.

in/put= op= employee_id,e_name,sal employee_id,e_name,sal,sum

select employee_id,e_name,sal, sum(sal) over() your_table

you have same value of sum each employee

oracle

No comments:

Post a Comment