Data sorting or simply sorting is the process of organizing list of records in database in logical order on the basis of key field of the records. It is the process of arranging the records in ascending or descending order.
- For example: If the records of students contains marks of different subjects and user just want to know the list according to the score in mathematics, then user uses the sort command.
- Sorted data is easy to handle than unsorted data. It helps to locate required record quickly.
Sorting are of two types:
- Sort ascending
- Sort descending