SQL Operator for Sorting Data: Ascending or Descending

The SQL operator used to display data in ascending or descending form is 'Order by'.

The 'Order by' clause is used to sort the result set of a SELECT statement in ascending or descending order. You can use one or more columns to sort the data. By default, the data is sorted in ascending order. To sort the data in descending order, you can use the DESC keyword.

Here is an example of how to use the 'Order by' clause to sort data in ascending order:

SELECT * FROM customers ORDER BY customer_name ASC;

This query will select all data from the 'customers' table and sort the results in ascending order by the 'customer_name' column.

Here is an example of how to use the 'Order by' clause to sort data in descending order:

SELECT * FROM customers ORDER BY customer_name DESC;

This query will select all data from the 'customers' table and sort the results in descending order by the 'customer_name' column.