How to get different term result in different column in sql?

Accepted answer

Hello Munir

Try this

0

I want result with other fields like subject,student name..

0

That can be solved by using pivot and unpivot relational operator. Here you can convert column to rows and vice versa.

https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-2017

0

Hi Munir, You can read below article, it will help you. https://www.c-sharpcorner.com/UploadFile/f0b2ed/pivot-and-unpovit-in-sql-server/

0