Abfragesyntax

.

Verwandte Themen

• Abfragen

• Abfrageoperatoren

• Abfragen von Daten in Stagingdateien

• Abfragen von Metadaten für bereitgestellte Dateien

Snowflake unterstützt das Abfragen mit standardmäßigen SELECT-Anweisungen und der folgenden Basissyntax:

[ WITH ... ]
SELECT
   [ TOP <n> ]
   ...
[ FROM ...
   [ AT | BEFORE ... ]
   [ CHANGES ... ]
   [ CONNECT BY ... ]
   [ JOIN ... ]
   [ PIVOT | UNPIVOT ... ] ]
   [ VALUES ... ]
   [ SAMPLE ... ]
[ WHERE ... ]
[ GROUP BY ...
   [ HAVING ... ] ]
[ QUALIFY ... ]
[ ORDER BY ... ]
[ LIMIT ... ]

Nächste Themen:

• WITH

• TOP <n>

• FROM

  • AT | BEFORE

  • CHANGES

  • CONNECT BY

  • JOIN

  • PIVOT

  • UNPIVOT

  • VALUES

  • SAMPLE / TABLESAMPLE

• WHERE

• GROUP BY

  • GROUP BY CUBE

  • GROUP BY GROUPING SETS

  • GROUP BY ROLLUP

  • HAVING

• QUALIFY

• ORDER BY

• LIMIT / FETCH