Home > database >  SQL server to a few lines of a field sum
SQL server to a few lines of a field sum

Time:09-28

Existing a result, it is necessary to sum of the values for cnt3, do not need to draw a sum value, but we need to distinguish between (the first line and second line values has been added to the 80, if he took one of the most close to more than 80, to 80 later add don't add, cnt3 is reverse), as shown in figure:

CodePudding user response:

Not understand requirements
  • Related