This is actual table
StudendID Studentname StudentMark
17 raja 80
17 raja 90
I want my result to be like below
StudendID Studentname StudentMark_1 StudentMark_2
17 raja 80 90
Pls help
What I have tried:
I want to know how to get my result using sql query , any idea