05-sqlite order BY to sort the result set

An overview of the ORDER BY statement

The

order BY statement is used to sort the result set based on the specified column.
The order BY statement sorts records by default in ascending order.
If you want to sort records in descending order, you can use the DESC keyword

Second, the name is displayed in alphabetical order

Syntax: SELECT * FROM Persons order by name;

Third, display name in alphabetical order, and display ID in numeric order

Syntax: SELECT * FROM Persons ORDER by Name,id;

Four, in reverse alphabetical display name

Syntax: SELECT * FROM Persons ORDER by name Desc;

The name is displayed in reverse order and the ID is displayed numerically.

VI. display name in reverse alphabetical order and display ID in reverse order

05-sqlite order BY to sort the result set