The query results in the database are obtained in a certain order.

The query results in the database are obtained in a certain order.

For example, if the database uses Chinese characters for weekly storage in May, you can use the following statement to sort the data in this order.

Order by field (XQ, '1', '2', '3', '4', '5', '6', 'day ')

Indicates that the returned column XQ is returned from Monday to Sunday.

Database query results are sorted by the length of a certain field (PASS) using the following statement

Select * from SSH. Person Order by length (PASS)