Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Want to display the marks as COLUMN as ROW in review wise in SQL?

on

I want to display the student as a number marks as a column wise (Review1,Review2,Review3) based on the semester id. I know We should use PIVOT to change row as a column. I have define schema below. I don't know how to proceed the query.

This is the schema I have:

enter image description here

This is the result I need:

enter image description here

Comments

Post a Comment