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