Above, how can the data in the table to check the results below that is of the same lines into one line of code and weight addition

CodePudding user response:

 
Select code, the sum (weight) as weight from trans group by code 

CodePudding user response:

Such as sum added group by upstairs

CodePudding user response:

Select code, the sum (weight) as weight from trans group by code

CodePudding user response:

 select code, the sum (weight) as weight from trans 
Group by code 

CodePudding user response:

 SELECT CODE AS "CODE (coding), SUM (WEIGHT) AS" WEIGHT (load) "
The FROM TRANS 
GROUP BY CODE 

CodePudding user response:

So the question comes, how to show the appearance of the format

CodePudding user response:

Select code, the sum (weight) as weight from trans group by code

CodePudding user response:

refer to 6th floor hp961218 response:

so the question comes, how to show that the format of the

Don't meet 1 nf, unless... Joining together,