You can use standard SQL features within the same query to make your statements more sophisticated.
For example, you can use ordered analytical functions in the following ways.
| Use an analytical function in this operation … | To … |
|---|---|
| INSERT … SELECT | populate a new column. |
| derived table | create a new table to participate in a complex query. |
Ordered analytical functions having different sort expressions are evaluated one after another, reusing the same spool file. Different functions having the same sort expression are evaluated simultaneously.