RegNO Name PaidAmount Class Section A100 AAAA 500 I A A200 BBBB 750 I A A100 AAAA 150 I A A300 CCCC 400 I A A400 DDDD 300 I A A100 AAAA 100 I A A300 cccc 350 I A A400 DDDD 450 I A
RegNO Name PaidAmount Class Section A100 AAAA 750 I A A200 BBBB 750 I A A300 CCCC 750 I A A400 DDDD 750 I A
SELECT RegNO, Name, SUM(PaidAmount), Class, Section FROM myTable GROUP BY RegNO, Name, Class, Section
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)