department wise Sum of salary of employee with each employee details : <p>I Have following table which contains details of Employee</p>

<pre><code>EmpId    EmpName   Mgr   Salary  Dept

1        Deepak     2     20000  1
2        Annu      NULL   22000  1
3        Jai        2     19500  1
4       Jitendra    1     18000  2
5       Vaishali    1     18000  2
6       Philip      4     15000  3
</code></pre>

<p>I wants to show salary of each dept with each employee details,if it repeats no issues as shown below</p>

<pre><code>EmpId    EmpName    Mgr   Salary    Dept   DeptSal

1        Deepak     2      20000    1        61500
2        Annu      NULL    22000    1        61500
3        Jai        2      19500    1        61500
4        Jitendra   1      18000    2        36000
5        Vaishali   1      18000    2        36000
6        Philip     4      15000    3        15000

</code></pre>
