The analytical clause used in the previous example indicates that the rows retrieved by the query are partitioned based on the value of the number of credits (noc) and, then in each group the rows are ordered according to the values of the gpa attribute.