1. A method executed by a computer system, comprising: receiving a query to perform an ordered analytic function, wherein the query contains a clause specifying creation of dynamic partitions, and wherein the clause contains a partitioning condition to specify the dynamic partitions, where the clause is of a type different from a PARTITION BY clause; and during processing of the query, identifying, by the computer system, the dynamic partitions based on evaluating the partitioning condition, wherein identifying the dynamic partitions comprises: creating a first table containing a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true; and using the first column of the first table to identify the dynamic partitions.