541 Transfer the Data 542 Transforming with gpload 542 Transforming with gpfdist and INSERT INTO SELECT FROM 544 Configuration File Format 544 XML Transformation Examples 545 Command-based External Scalar correlated subquery 598 Example 2 – Correlated EXISTS subquery 598 Example 3 - CSQ in the Select List 599 Example 4 - CSQs connected by OR Clauses 599 VMware Greenplum 7 Documentation VMware Row Constructors 600 Expression Evaluation Rules 601 WITH Queries (Common Table Expressions) 602 SELECT in a WITH Clause 602 Data-Modifying Statements in a WITH clause 607 Considerations 608 Using Functions

738 Transfer the Data 739 Transforming with gpload 739 Transforming with gpfdist and INSERT INTO SELECT FROM 740 Configuration File Format 741 XML Transformation Examples 742 Command-based External the Select List 795 Example 4 - CSQs connected by OR Clauses 795 Array Constructors 795 Row Constructors 796 Expression Evaluation Rules 797 WITH Queries (Common Table Expressions) 798 SELECT in a VMware Greenplum 6 Documentation VMware, Inc 60 ROLLBACK TO SAVEPOINT 1330 SAVEPOINT 1330 SELECT 1331 SELECT INTO 1331 SET 1331 SET CONSTRAINTS 1332 SET ROLE 1332 SET SESSION AUTHORIZATION 1332 SET

VMware Greenplum 6 Documentation VMware by Broadcom 35 Transforming with gpfdist and INSERT INTO SELECT FROM 749 Configuration File Format 749 XML Transformation Examples 751 Command-based External Scalar correlated subquery 803 Example 2 – Correlated EXISTS subquery 803 Example 3 - CSQ in the Select List 803 Example 4 - CSQs connected by OR Clauses 803 Array Constructors 804 Row Constructors VMware by Broadcom 38 Expression Evaluation Rules 806 WITH Queries (Common Table Expressions) 807 SELECT in a WITH Clause 807 Data-Modifying Statements in a WITH clause 811 Using Functions and Operators

711 Transfer the Data 712 Transforming with gpload 713 Transforming with gpfdist and INSERT INTO SELECT FROM 714 Configuration File Format 714 XML Transformation Examples 716 Command-based External the Select List 767 Example 4 - CSQs connected by OR Clauses 767 Array Constructors 768 Row Constructors 769 Expression Evaluation Rules 770 WITH Queries (Common Table Expressions) 770 SELECT in a Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional

717 Transfer the Data 718 Transforming with gpload 718 Transforming with gpfdist and INSERT INTO SELECT FROM 720 Configuration File Format 720 XML Transformation Examples 721 Command-based External the Select List 774 Example 4 - CSQs connected by OR Clauses 774 Array Constructors 775 Row Constructors 776 Expression Evaluation Rules 777 WITH Queries (Common Table Expressions) 778 SELECT in a 1313 RETRIEVE 1314 REVOKE 1314 ROLLBACK 1315 ROLLBACK TO SAVEPOINT 1315 SAVEPOINT 1316 SELECT 1316 SELECT INTO 1316 SET 1317 SET CONSTRAINTS 1317 SET ROLE 1317 SET SESSION AUTHORIZATION 1317 SET

836 Transfer the Data 837 Transforming with gpload 838 Transforming with gpfdist and INSERT INTO SELECT FROM 839 Configuration File Format 839 XML Transformation Examples 841 Command-based External Scalar correlated subquery 892 Example 2 – Correlated EXISTS subquery 892 Example 3 - CSQ in the Select List 892 Example 4 - CSQs connected by OR Clauses 893 Array Constructors 893 Row Constructors Inc. 54 WITH Queries (Common Table Expressions) 896 WITH Queries (Common Table Expressions) 0 SELECT in a WITH Clause 896 Data-Modifying Statements in a WITH clause 900 Using Functions and Operators

827 Transfer the Data 828 Transforming with gpload 829 Transforming with gpfdist and INSERT INTO SELECT FROM 830 Configuration File Format 830 XML Transformation Examples 832 Command-based External Scalar correlated subquery 883 Example 2 – Correlated EXISTS subquery 883 Example 3 - CSQ in the Select List 883 Example 4 - CSQs connected by OR Clauses 884 Array Constructors 884 Row Constructors VMware Greenplum v6.18 Documentation VMware, Inc. 53 WITH Queries (Common Table Expressions) 0 SELECT in a WITH Clause 887 Data-Modifying Statements in a WITH clause 891 Using Functions and Operators

VMware Tanzu Greenplum 6 Documentation VMware, Inc. 31 Transforming with gpfdist and INSERT INTO SELECT FROM 713 Configuration File Format 713 XML Transformation Examples 714 Command-based External Scalar correlated subquery 766 Example 2 – Correlated EXISTS subquery 766 Example 3 - CSQ in the Select List 766 Example 4 - CSQs connected by OR Clauses 767 Array Constructors 767 Row Constructors Documentation VMware, Inc. 34 Expression Evaluation Rules 769 WITH Queries (Common Table Expressions) 770 SELECT in a WITH Clause 770 Data-Modifying Statements in a WITH clause 774 Using Functions and Operators

611 Transfer the Data 613 Transforming with gpload 613 Transforming with gpfdist and INSERT INTO SELECT FROM 614 Configuration File Format 614 XML Transformation Examples 616 VMware Tanzu Greenplum the Select List 662 Example 4 - CSQs connected by OR Clauses 663 Array Constructors 663 Row Constructors 664 Expression Evaluation Rules 665 WITH Queries (Common Table Expressions) 666 SELECT in a Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional

759 Transfer the Data 760 Transforming with gpload 761 Transforming with gpfdist and INSERT INTO SELECT FROM 762 Configuration File Format 762 XML Transformation Examples 764 Command-based External Scalar correlated subquery 815 Example 2 – Correlated EXISTS subquery 815 Example 3 - CSQ in the Select List 815 Example 4 - CSQs connected by OR Clauses 816 Array Constructors 816 Row Constructors VMware Greenplum v6.17 Documentation VMware, Inc. 49 WITH Queries (Common Table Expressions) 0 SELECT in a WITH Clause 819 Data-Modifying Statements in a WITH clause 823 Using Functions and Operators