The data in a specified column of a table can be sorted in ascending or descending order of the values.

The following figure shows, as an example of data sorting, the procedure for retrieving form numbers, product codes, and quantities ordered from the stock table and then sorting the retrieved items in ascending order of the product codes.

Figure 2-36 Data sorting example