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.