Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0811

D toc

D s ed
editionsawsent,awspro,awspr,gdpent,gdppro,gdppr,gdpst

...

Supported syntax by datastore

Individual datastores may have differences in the supported syntax. For more information on the supported syntax for your datastore, please see the documentation for the connection type. See Connection Types.your datastore. 

General Examples

Here are some basic SQL examples to get started.

...

Code Block
SELECT lastName,firstName FROM "DB1"."table2" WHERE invoiceAmt > 10000;

Multi-line statement for imported datasets

D s ed

The following example uses a multi-line SQL sequence to import a dataset:

Info

NOTE: Multi-line SQL support is considered an advanced use case. This feature must be enabled.

The following example inserts values in the TABLE_INVENTORY table and then queries the table. It utilizes Oracle syntax:

Code Block
INSERT INTO "SALES"."TABLE_INVENTORY" ("ID", "AVAILABILITY") VALUES (1, 10);
SELECT * FROM "SALES"."TABLE_INVENTORY";

D s also
labelsql