Query syntax¶ Snowflake supports querying using standard SELECT statements and the following basic syntax: CopyExpand[ WITH ... ] SELECT [ TOP <n> ] ... [ INTO ... ] [ FROM ... [ AT | BEFORE ... ] [ CHANGES ... ] [ CONNECT BY ... ] [ JOIN ... ] [ ASOF JOIN ... ] [ LATERAL ... ] [ MATCH_RECOGNIZE ... ] [ PIVOT | UNPIVOT ... ] [ VALUES ... ] [ SAMPLE ... ] [ RESAMPLE ... ] [ SEMANTIC_VIEW( ... ) ] ] [ WHERE ... ] [ GROUP BY ... ] [ HAVING ... ] [ QUALIFY ... ] [ ORDER BY ... ] [ LIMIT ... ] [ FOR UPDATE ... ] Show lessSee moreScroll to top Next Topics: WITH TOP <n> INTO FROM AT | BEFORE CHANGES CONNECT BY JOIN ASOF JOIN LATERAL MATCH_RECOGNIZE PIVOT UNPIVOT VALUES SAMPLE / TABLESAMPLE RESAMPLE SEMANTIC_VIEW WHERE GROUP BY GROUP BY CUBE GROUP BY GROUPING SETS GROUP BY ROLLUP HAVING QUALIFY ORDER BY LIMIT / FETCH FOR UPDATE