Superb explanation 👌 👏 👍
Bro, I am not getting same output,After executing select statement inside cte1. I am getting B English 1For yourB English 5
what if you have 10 subject . are you going to hardcode it. That means will you write 10 times case statement. Please bring a different approach.
Superb explanation 👌 👏 👍
Bro, I am not getting same output,
After executing select statement inside cte1. I am getting
B English 1
For your
B English 5
what if you have 10 subject . are you going to hardcode it. That means will you write 10 times case statement. Please bring a different approach.