Home > database >  Worry, query statistics problem such as online
Worry, query statistics problem such as online

Time:10-05

I want to statistical data in a table, there are three columns
A b c
1 2 3
1 2 3
1 3
3 2
Requirements: such as statistical values
1In column b, c as 1 1/2 it counts as 1, and converted into a 1 in a column, so on,
If the column indicator for n, how to calculate the value of n? How to statistical number? Please advice!

CodePudding user response:

Didn't see

CodePudding user response:

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


In column a count of 1, such as in the first line has two columns have value, is the number of "temperature" count 1/2, 1 column has a value in the second line, the "temperature" counting the number of 1, in this case "temperature" count should be 2 , how to calculate the value of the denominator? How to statistical number? Please advice!

CodePudding user response:

Ah, the Chinese even the Chinese meaning expression is not clear, what to learn English?

Not understand your meaning

CodePudding user response:

I also want to know, thank you LZ.