I want to statistical data in a table, there are n columns
A b c d
The length of the temperature mechanics
Mechanical temperature length
The length of the temperature


Al columns of data count is 1, the other columns except Ann, for the "length", for example, the value of a column he is 1, he appeared on the c column in the second line, because a, b column has a value, d is empty, counting the "length" in the column c for a third, the third line for 1/2 "length" count, first read a value in a column, and then the corresponding lookup count in the other columns, use the SQL language how to do? Please advice!
Quick etc.

CodePudding user response:

Pay attention to pick up points

CodePudding user response:

Pick up points first!