Question

How do you sort the data of the table in a database?​

Answer 1

Answer:

When you specify ASC in the ORDER BY clause, the result will be sorted in ascending order, and if you specify DESC, then the result will be sorted in descending order. The default sorting order is Ascending, so if we do not specify the sorting order, then the query result will be sorted in ascending order.

Follow =follow

Answer 2

Answer:

To sort records:

1. Select a field you want to sort by. In this example, we will sort by customers' last names.
2. Click the Home tab on the Ribbon, and locate the Sort & Filter group.
3. Sort the field by selecting the Ascending or Descending command.
4. Select Ascending to sort text A to Z or to sort numbers from smallest to largest. We will select this in our example because we want the last names to be in A-to-Z order.
5. Select Descending to sort text Z to A or to sort numbers from largest to smallest.
6. The table will now be sorted by the selected field.
7. To save the new sort, click the Save command on the Quick Access toolbar.

Explanation:

HOPE THIS HELPS MATE!!.