As shown in figure, often using count knows that, if the result of the select column have different values will generate n rows of data, if you have the same value that the column will produce an entire column will have the same values, I have a small demand now, want to have the same value to display only the data to the first line:

Code snippets:

CodePudding user response:

The union after the first line of the count

CodePudding user response:

Writing can be like this:

I write in a branch to separate conditions

CodePudding user response:

After the data volume is not large, out in the DataTable direct cycle change can