Kiran Karale

Kiran Karale

  • NA
  • 390
  • 210.9k

Sql Query Problem

Apr 15 2011 1:55 AM
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


Answers (1)