SQL-ORDER BY multi-field sorting (ascending, descending), SQL-order ascending

SQL-ORDER BY multi-field sorting (ascending, descending), SQL-order ascending

Order by _ column1, _ column2;/* _ column1 in ascending ORDER, _ column2 in ascending ORDER */order by _ column1, _ column2 DESC;/* _ column1 in ascending ORDER, _ column2 descending ORDER */order by _ column1 DESC, _ column2;/* _ column1 descending ORDER, _ column2 Ascending ORDER */order by _ column1 DESC, _ column2 DESC; /* _ column1 in descending order, _ column2 in descending order */

In SQL, sort by a field in ascending order and then by a field in descending order.

Order by is followed by the first
Order by position, money desc, top desc
Which means
Positions are sorted in ascending order. When positions are equal, they are sorted in descending order of money,
Position and money are sorted by top in descending order

How to sort a field in an SQL table in ascending order

Select * from table name order by field name