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