GROUP BY

Syntax of Analysis Statements

The syntax of a complete analysis statement is as follows:

1
2
3
4

SELECT [DISTINCT] (* | expression) [AS alias] [, ...]
[GROUP BY expression [, ...] [HAVING predicates]]
[ORDER BY expression [ASC | DESC] [, ...]]
[LIMIT size OFFSET offset]

Where, GROUP BY indicates grouping by value. The following part describes parameters and examples for the GROUP BY syntax.

Grouping by Field Value

Group data by field value to check different values of the age field.

1

*|SELECT age GROUP BY age

Grouping by Field Alias

Rename account_number to num and group data by the alias num.

1

*|SELECT account_number AS num GROUP BY num

Grouping by Multiple Fields

View the distribution of account_number and age, grouped by multiple fields.

1

*|SELECT account_number AS num, age GROUP BY num, age

Using SQL Functions

Use a SQL function to count log entries based on the length of the lastname field.

For details about functions, see Function.

1

*|SELECT LENGTH(lastname) AS len, COUNT(*) AS count GROUP BY LENGTH(lastname)