meterid consumption total 1 100 1 150 1 200 1 300
meterid consumption total 1 100 100 1 150 250 1 200 450 1 300 750
select meterid,consumption,sum(consumption) as total from temp_reading group by meterid;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)