Ordered analytical functions are permitted in the following database query objects: Views Macros Derived tables INSERT ... SELECT