クエリ構文¶

Snowflakeは、標準の SELECT ステートメントと次の基本構文を使用したクエリをサポートしています。

[ WITH ... ] SELECT [ TOP <n> ] ... [ INTO ... ] [ FROM ... [ AT | BEFORE ... ] [ CHANGES ... ] [ CONNECT BY ... ] [ JOIN ... ] [ ASOF JOIN ... ] [ LATERAL ... ] [ MATCH_RECOGNIZE ... ] [ PIVOT | UNPIVOT ... ] [ VALUES ... ] [ SAMPLE ... ] [ SEMANTIC_VIEW( ... ) ] ] [ WHERE ... ] [ GROUP BY ... [ HAVING ... ] ] [ QUALIFY ... ] [ ORDER BY ... ] [ LIMIT ... ] [ FOR UPDATE ... ] 

Copy

次のトピック：