By default, MapInfo Pro sorts the table in ascending order. If you sort using a character field, ascending order means that A's appear above B's, etc. If you sort using a numeric field, ascending order means that small numbers appear above large numbers.
To sort in descending order, so that large numbers appear above small numbers, place the word desc after the column name in the Group By Columns field. For example, if you query the World table, the following Order By criterion:
Order By Columns: Population desc sorts the table by the Population column, in descending order.
When MapInfo Pro performs a multi-level sort, each level of the sort has its own ascending/descending setting. Thus, the following example performs an ascending sort by the State column, and then performs a descending sort by the Population column:
Select Columns: *
From Tables: City_1K
Order By Columns: State, Population desc