Page 231 - IT_V1.0_Class10
P. 231
Sorting Data
Sorting means to arrange the data of a table in a particular order like in ascending or descending order. There
are two options for sorting records of a table, ‘Sort Ascending’ and ‘Sort Descending’.
The steps to sort records in ascending order are as follows:
Step 1: Open the Student table by double-clicking on its name in the Tables pane.
The Student table opens in the Table Data View window.
Step 2: Click on the field (column) based on which sorting is to be applied. In our case, we have clicked on
the CLASS field.
All records of the CLASS field gets highlighted.
Step 3: Click on Sort Ascending button from the Table Data toolbar to sort the records of the table in
ascending order based on the CLASS field.
3
2
The table is sorted in ascending order based on the CLASS field.
The steps to sort records in descending order are as follows:
Step 1: Click on the field (column) based on which sorting is to be applied.
In our case, we have clicked on the CLASS field. All records with field CLASS gets highlighted.
Step 2: Click on Sort Descending button from the Table Data toolbar to sort the records of the table
in descending order of CLASS.
2
1
The table is sorted in descending order based on the CLASS field.
Sort Records by Applying Multiple Sort Criteria
While sorting, if two records have the same value, then multiple sorting
can be used. Here, another criteria is used for sorting those records
where values are the same.
The steps to sort records by applying multiple sort criteria are as follows:
Step 1: Open the Student table by double-clicking on its name in the
Tables pane of the database window.
Starting with LibreOffice Base 229

