Scribd
Upload
22 views1 page

Snowflake Query Syntax Overview

The document discusses the basic query syntax supported by Snowflake including SELECT statements, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT and other clauses. It also lists related topics for additional details.

Uploaded by

demorepo99
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views1 page

Snowflake Query Syntax Overview

The document discusses the basic query syntax supported by Snowflake including SELECT statements, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT and other clauses. It also lists related topics for additional details.

Uploaded by

demorepo99
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

4/29/24, 2:54 PM Query Syntax | Snowflake Documentation

Reference SQL Command Reference Query Syntax


Query Syntax
Snowflake supports querying using standard SELECT statements and the following
basic syntax:
[ WITH ... ] Copy
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 ... ]

Next Topics:
WITH
TOP <n>
INTO
FROM
AT | BEFORE
CHANGES
CONNECT BY
JOIN
ASOF JOIN
LATERAL
[Link] 1/1

You might also like