首页 文库资料 文章资讯  上传文档  发布文章  登录账户

分类

全部数据库(12)Greenplum(12)

语言

全部英语(11)中文（简体）(1)

格式

全部PDF文档 PDF(12)
 
本次搜索耗时 0.897 秒，为您找到相关结果约 12 个.

  • pdf文档 Greenplum Database 管理员指南 6.2.1

    max(id) AS id FROM t1; =# CREATE VIEW v2 AS SELECT t1.val FROM t1 JOIN v1 USING (id); =# CREATE VIEW v3 AS SELECT val || f() FROM t1; =# CREATE VIEW v5 AS SELECT f(); =# CREATE SCHEMA mytest; =# CREATE 中。例如： =# WITH v AS (SELECT a, sum(b) as s FROM T GROUP BY a) SELECT * FROM v as v1, v as v2, v as v3 WHERE v1.a < v2.a AND v1.s < v3.s AND v1.a = 10 AND v2.a = 20 AND v3.a = 30; Orca 还可以处理这些类型的 AS ( SELECT a, s FROM cte1 where s > 1000 ) SELECT * FROM cte1 as v1, cte2 as v2, cte2 as v3 WHERE v1.a < v2.a AND v1.s < v3.s;  嵌套CTE =# WITH v AS ( WITH w AS ( SELECT
    0 码力 | 416 页 | 6.08 MB | 1 年前
    3

  • pdf文档 VMware Greenplum v6.18 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 1959 页 | 19.73 MB | 1 年前
    3

  • pdf文档 VMware Greenplum v6.19 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 1972 页 | 20.05 MB | 1 年前
    3

  • pdf文档 VMware Greenplum v6.17 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 1893 页 | 17.62 MB | 1 年前
    3

  • pdf文档 VMware Tanzu Greenplum v6.20 Documentation

    Greenplum v6.20 Documentation VMware, Inc. 765 v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 1988 页 | 20.25 MB | 1 年前
    3

  • pdf文档 VMware Greenplum 6 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts VMware by Broadcom 608 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 2445 页 | 18.05 MB | 1 年前
    3

  • pdf文档 VMware Greenplum 7 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 2221 页 | 14.19 MB | 1 年前
    3

  • pdf文档 VMware Tanzu Greenplum v6.21 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 2025 页 | 33.54 MB | 1 年前
    3

  • pdf文档 VMware Greenplum 6 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 2374 页 | 44.90 MB | 1 年前
    3

  • pdf文档 VMware Tanzu Greenplum v6.23 Documentation

    view | ref_object ------------+------------ v1 | t1 v2 | t1 v2 | t1 v3 | t1 mytest.vt1 | t1 mytest.v2a | t1 mytest.v2a | t1 (7 rows) The query performs casts | public | t1 v2 | public | t1 v2 | public | t1 v2 | public | v1 v3 | public | t1 vm1 | public | mytest.tm1 mytest.vm1 | mytest | t1 vm2 | public + | | | JOIN v1 USING (id)); v3 | t1 | 2 | CREATE VIEW v3 AS SELECT (t1.val || f()) + | | | FROM t1; v2
    0 码力 | 2298 页 | 40.94 MB | 1 年前
    3
共 12 条
  • 1
  • 2
前往
页
相关搜索词
GreenplumDatabase管理管理员指南VMwarev618Documentation1917Tanzu202123