For biee's answer, use unin.

For biee's answer, use unin. The SQL statement used for unin is a collection. In biee, unin plays a unique and powerful role. In biee, we can use the unin function to complete grouping. The specific method is to use unin to manually create "dimension values" to complete different business groups. For example, calculate the percentage (%) of a record, sum of a record, and so on. At the same time, we use the automatic sorting of numbers in SQL statements to sort groups. For example, we create an "array column" for the "result column". Then, different columns use different numbers in the columns corresponding to the result column according to different requirements of the sequence. In fact, to understand the true meaning of the above grouping practices, we can look at the SQL statements. By reading the source code, we know that for each column, biee uses the group by grouping function to group the column. Finally, we get the results of the authoritarian SQL operation.