Question related to Salary

Question

Hi,

 

I want all the question with answer  related to salary.

for e.g

1) how to find departmentwise salary from table

2) how to add salary

 e.g 

 empid   salary

1             1000

2              2000

3              3000

 

i want o/p like this

 

empid    salary  

1        3000(1000+2000)

2        3000(2000+3000)

3        3000