05-SQLite order by sorts result sets, 05-sqliteorder

05-SQLite order by sorts result sets, 05-sqliteorder
I. Overview of order by statements

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

2. Display name in alphabetical order

Syntax: select * from personsorder by name;

3. name is displayed in alphabetical order and id is displayed in numerical order.

Syntax: select * from personsorder by name, id;

4. Display name in alphabetical order

Syntax: select * from persons order by name desc;

5. Display name in alphabetical order and id in numerical order

6. Display name in alphabetical order and id in numerical descending order