Home > database >  If sSaleOrderNo field values are the same, how to add those fQ field
If sSaleOrderNo field values are the same, how to add those fQ field

Time:10-09

If sSaleOrderNo field values are the same, how the fQ field together?

CodePudding user response:

 SELECT sSaleOrderNo, SUM (fQ) FROM the name of the table GROUP BY sSaleOrderNo 

CodePudding user response:

Grouping query summary fQ:
The select sSaleOrderNo, sum (fQ) from the name of the table group by sSaleOrderNo

CodePudding user response:

Check if it is more than one table to make multiple fields, but also to meet the above condition how to write
  • Related