Aaa and BBB
101
102
101
102 2
103

The table name: table, field aaa, BBB

Need to get the following query results, it is necessary to put the same record in aaa BBB field value summation,
Aaa count (aaa)
13 101
102
103

Don't know whether the SQL directly supports this practice, ever remember informaker group of function can be realized, but forget, for help, thanks a lot!

CodePudding user response:

Create a subtotal column group, and then placed a calculated column to write the sum (BBB)

CodePudding user response:

The

refer to the original poster swjia8315 response:

aaa BBB
101
102
101
102 2
103

The table name: table, field aaa, BBB

Need to get the following query results, it is necessary to put the same record in aaa BBB field value summation,
Aaa count (aaa)
13 101
102
103

Don't know whether the SQL directly supports this practice, ever remember informaker group of function can be realized, but forget, for help, thanks a lot!

SQL can be achieved directly in the

Select the aaa, the sum (BBB) from table group by aaa

Can be