Hi I have an Sql Table Like this
My Table
StudentID paidId Amount
1140 25 100
1140 25 200
1140 25 300
1141 30 500
I Want A table in Following format
i want To show Amount in This format
How I can Get a result Like
StudentID paidId Amount
1140 25 600
1141 30 500