I want to take out the inside of the each category in the front of the number is 1 a data! You don't have any good opinion?

CodePudding user response:

The SELECT MAX (number) FROM TABLE_NAME GROUP BY classification;

CodePudding user response:

Front don't quite understand what meaning is a data, such as classification, 102, in the front of the number 1 is a data this article 17 101 5 0?

CodePudding user response:

For example I'm going to take each category in the front of the number is equal to 3 inside a data! This column is the condition of column number