You can do that through editing your query in SQL mode (right-click on the query name and choose relevant menu item). An editor window opens and the SQL language query is presented.
It takes the general form of SELECT <talias>.<field>, … FROM <table> AS <talias>, … WHERE <selection equation> ORDER BY <talias>.<field>, …
The sorting order is defined by the ORDER BY
clause telling which fields are used to sort the records. The leftmost field is the first key considered, then equal records are sorted on the second field, etc.
Reading introduction to the SQL language is a valuable help. There are some tips quite well explained in the Base user’s guide.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!