how to count the total salary which based on Deptname wise.
i have 50rows with empid,empname,deptname,salary.
i want to count the total salary dept wise.
please help me,
Thanks in advance.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ranjit PowarPosted Dec 21, 2015, 2:16 AM
Pavan BujjiPosted Dec 21, 2015, 1:49 AM
Ranjit PowarPosted Dec 19, 2015, 7:55 AM
Ranjit PowarPosted Dec 19, 2015, 7:44 AM
Pavan BujjiPosted Dec 19, 2015, 2:50 AM
Pavan BujjiPosted Dec 19, 2015, 2:48 AM
Ranjit PowarPosted Dec 19, 2015, 2:43 AM
Rajeesh MenothPosted Dec 19, 2015, 2:41 AM
- SELECT department_id, SUM(salary)
- FROM employees
- GROUP BY department_id;
More Reference :Pavan BujjiPosted Dec 19, 2015, 2:40 AM
Ranjit PowarPosted Dec 19, 2015, 2:25 AM
Pavan BujjiPosted Dec 19, 2015, 1:37 AM
Pavan BujjiPosted Dec 19, 2015, 1:00 AM
Manas MohapatraPosted Dec 19, 2015, 12:58 AM
Pavan BujjiPosted Dec 19, 2015, 12:56 AM
Manas MohapatraPosted Dec 19, 2015, 12:38 AM
Ranjit PowarPosted Dec 18, 2015, 11:59 PM
Pavan BujjiPosted Dec 18, 2015, 11:47 PM
Ranjit PowarPosted Dec 18, 2015, 11:38 PM
Employee group by deptname
If problem soved, mark it as correct answer.