......................................................................645 31.15. The Connection Service File .....................................................................................646 31 entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................605 31.15. The Connection Service File ..............................................................................606 31.16. LDAP entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................690 31.16. The Connection Service File ..............................................................................690 31.17. LDAP entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................729 31.16. The Connection Service File .....................................................................................729 31 entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................642 31.15. The Connection Service File ..............................................................................643 31.16. LDAP entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................678 31.15. The Connection Service File .....................................................................................679 31 entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................669 31.16. The Connection Service File ..............................................................................669 31.17. LDAP entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................710 31.16. The Connection Service File .....................................................................................711 31 entirely determined by the OVER clause. The rows considered by a window function are those of the “virtual table” produced by the query’s FROM clause as filtered by its WHERE, GROUP BY, and HAVING clauses means of different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering of rows is not important. It

......................................................................546 30.14. The Connection Service File .....................................................................................546 30 transformations performed on the table derived in the FROM clause. All these transformations produce a virtual table that provides the rows that are passed to the select list to compute the output rows of the reference is listed in the FROM clause they are cross-joined (see below) to form the intermediate virtual table that can then be subject to transformations by the WHERE, GROUP BY, and HAVING clauses and

......................................................................515 30.14. The Connection Service File ..............................................................................515 30.15. LDAP table derived in the FROM clause. All these transforma- 72 Chapter 7. Queries tions produce a virtual table that provides the rows that are passed to the select list to compute the output rows of the reference is listed in the FROM clause they are cross-joined (see below) to form the intermediate virtual table that can then be subject to transformations by the WHERE, GROUP BY, and HAVING clauses and