Query Constructs

Snowflake supports querying using standard SELECT statements and the following basic syntax:

[ WITH ... ]
SELECT ...
FROM ...
   [ AT | BEFORE ... ]
   [ SAMPLE ... ]
   [ JOIN ... ]
[ WHERE ... ]
[ GROUP BY ... ]
[ HAVING ... ]
[ ORDER BY ... ]
[ VALUES ... ]
[ LIMIT ... ]

Descriptions of each construct: