Abfragesyntax¶
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: