Column values in a table view can be sorted ascending or descending. By hovering over the column header of the field which you want to sort and clicking on the arrow in the column header, a dropdown menu appears including Sort ascending and Sort descending options. When you choose either of those options by clicking, the appropriate icon appears in the column header, indicating that the column values are sorted. Please note that sorting is possible only by a single field (column) currently. Similarly, you can sort the values in the fields of your form views by right-clicking on the selected field and selecting the appropriate option from the arrow dropdown menu.
On the screenshot below, the icon in the "CdId" column header indicates that the values in this column are sorted by the "CdId" field in descending order.
Sorting in a view (grid or form view) will be preserved even after you run a query.