Loading

Calculate total fee of each teacher in all department using sql query

abhijit dhanwate

5y1.2kLearn iOS Programming

Below is Teacher table and output is given in same image

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
1. SELECT Teacher, [Science], [Commerce], [Art]
2. FROM
3. (
4. SELECT Dept, Teacher, [Fee]
5. FROM TeacherDtl
6. WHERE Teacher <> ''
7. ) dt
8. PIVOT(SUM([Fee]) FOR [Dept] IN([Science], [Commerce], [Art])) pvt
0

Nikunj Satasiya5y ago

Hi Abhijit, You can try this solution.

https://www.codingvila.com/2019/05/pivot-and-unpivot-in-sql-server-with-example.html

0

Amit Gupta5y ago

It can be achieved using pivot function, first try by yours https://www.c-sharpcorner.com/UploadFile/f0b2ed/pivot-and-unpovit-in-sql-server/#:~:text=Pivot%20and%20Unpivot%20in%20SQL%20are%20two%20relational%20operators%20that,column%20level%20to%20row%20level.

+1