A shaft corresponds to multiple devices, equipment list with id, id of shaft, water consumption, according to the different shaft id the sum total of the water consumption of the corresponding equipment!!!!!! For a great god

CodePudding user response:

The lifting id, select sum (water) from the as water equipment table group by shaft id

CodePudding user response:

As a
Select sum (water) from the table group by shaft ID
The process of