Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

ORDER BY

Updated on 2025-01-20 GMT+08:00

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, ORDER BY indicates sorting by field value. The following part describes parameters and examples for the ORDER BY syntax.

Sorting Data by Field Value

1
SELECT age ORDER BY age DESC
Table 1 Sorting by field value

age

28

32

32

36

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback