Query syntax¶
Snowflake supports querying using standard SELECT statements and the following basic syntax:
[ WITH ... ]
SELECT
[ TOP <n> ]
...
[ INTO ... ]
[ FROM ...
[ AT | BEFORE ... ]
[ CHANGES ... ]
[ CONNECT BY ... ]
[ JOIN ... ]
[ ASOF JOIN ... ]
[ LATERAL ... ]
[ MATCH_RECOGNIZE ... ]
[ PIVOT | UNPIVOT ... ]
[ VALUES ... ]
[ SAMPLE ... ] ]
[ WHERE ... ]
[ GROUP BY ...
[ HAVING ... ] ]
[ QUALIFY ... ]
[ ORDER BY ... ]
[ LIMIT ... ]
[ FOR UPDATE ... ]
Next Topics: