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, wherein the clause contains a partitioning condition to specify the dynamic partitions, and wherein receiving the query comprises receiving a Structured Query Language (SQL) query; and during processing of the query, identifying the dynamic partitions based on evaluating the partitioning condition, wherein processing the query comprises: redistributing input data across plural access modules; after redistributing, performing at each of the plural access modules: sorting the input data according to at least one attribute specified in a clause in the query that specifies ordering of the input data; and identifying the dynamic partitions in the sorted input data.