2. Ordering

You can order table rows by the values of a particular column simply by clicking the column header. The rows will be ordered in ascending order (the lowest values will be at the top). If you click the same column again, the table will be re-ordered in descending order. Upon the third click, the column ordering is canceled. Ordering by a particular column is indicated by the symbol for ascending order and by the symbol for descending order. These symbols are displayed in the column header to the right of the column title. If a table is ordered by a column, and you click the header of another column, ordering by the former column is not canceled but is assigned a lower priority – it is applied when values of the column selected later are the same.
If a table is ordered, it has the symbol in the upper left corner. A click on it cancels all ordering of the table.
You should keep in mind that this technique does not change the real order of the table rows in the table data, but only the view of this data. When you cancel ordering, the data is displayed in the order in which it is physically stored again.
In our example with the CD database, you can click, for example, the year column to order the albums by the year in which they were released, starting from the oldest ones.
Next: Filter