Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.

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