Which of the following actions cannot be performed using the ORDER BY clause?

The ORDER BY clause in SQL is primarily used for sorting the results of a query. This clause allows for sorting by various fields, whether in ascending or descending order.

Sorting by one or more fields is a fundamental option provided by the ORDER BY clause, making it a basic functionality of SQL. It is commonly used to organize the output based on specific criteria, such as names or dates.

Sorting data in descending order is also a typical use of the ORDER BY clause, allowing for the results to be presented from the highest to lowest values. Similarly, sorting data in ascending order is the default behavior if no specific order is designated, confirming the flexibility of the ORDER BY clause.

However, the limitation arises when considering resident tables. Within Qlik Sense and in general SQL contexts, the ORDER BY clause operates on the results derived from a single dataset or table. Sorting data from multiple resident tables cannot be achieved directly with the ORDER BY clause. For that scenario, data from multiple tables should be appropriately combined (using JOINs or UNIONs) into a single dataset first, after which the ORDER BY clause can be applied to the combined result set.

Thus, the inability to use the ORDER BY clause for sorting data from multiple resident tables is what makes this the