| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/sql/select |
| Français | https://docs.snowflake.com/fr/sql-reference/sql/select |
| Deutsch | https://docs.snowflake.com/de/sql-reference/sql/select |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/sql/select |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/sql/select |
| Português | https://docs.snowflake.com/pt/sql-reference/sql/select |
| Get started | https://docs.snowflake.com/en/user-guide-getting-started |
| Guides | https://docs.snowflake.com/en/guides |
| Developer | https://docs.snowflake.com/en/developer |
| Reference | https://docs.snowflake.com/en/reference |
| Release notes | https://docs.snowflake.com/en/release-notes/overview |
| Tutorials | https://docs.snowflake.com/en/tutorials |
| Status | https://status.snowflake.com |
| Overview | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Query syntax | https://docs.snowflake.com/en/sql-reference/constructs |
| SELECT | https://docs.snowflake.com/en/sql-reference/sql/select |
| WITH | https://docs.snowflake.com/en/sql-reference/constructs/with |
| TOP | https://docs.snowflake.com/en/sql-reference/constructs/top_n |
| INTO | https://docs.snowflake.com/en/sql-reference/constructs/into |
| FROM | https://docs.snowflake.com/en/sql-reference/constructs/from |
| AT | https://docs.snowflake.com/en/sql-reference/constructs/at-before |
| BEFORE | https://docs.snowflake.com/en/sql-reference/constructs/at-before |
| CHANGES | https://docs.snowflake.com/en/sql-reference/constructs/changes |
| CONNECT BY | https://docs.snowflake.com/en/sql-reference/constructs/connect-by |
| JOIN | https://docs.snowflake.com/en/sql-reference/constructs/join |
| ASOF JOIN | https://docs.snowflake.com/en/sql-reference/constructs/asof-join |
| LATERAL | https://docs.snowflake.com/en/sql-reference/constructs/join-lateral |
| MATCH_RECOGNIZE | https://docs.snowflake.com/en/sql-reference/constructs/match_recognize |
| PIVOT | https://docs.snowflake.com/en/sql-reference/constructs/pivot |
| UNPIVOT | https://docs.snowflake.com/en/sql-reference/constructs/unpivot |
| VALUES | https://docs.snowflake.com/en/sql-reference/constructs/values |
| SAMPLE / TABLESAMPLE | https://docs.snowflake.com/en/sql-reference/constructs/sample |
| RESAMPLE | https://docs.snowflake.com/en/sql-reference/constructs/resample |
| SEMANTIC_VIEW | https://docs.snowflake.com/en/sql-reference/constructs/semantic_view |
| WHERE | https://docs.snowflake.com/en/sql-reference/constructs/where |
| GROUP BY | https://docs.snowflake.com/en/sql-reference/constructs/group-by |
| GROUP BY CUBE | https://docs.snowflake.com/en/sql-reference/constructs/group-by-cube |
| GROUP BY GROUPING SETS | https://docs.snowflake.com/en/sql-reference/constructs/group-by-grouping-sets |
| GROUP BY ROLLUP | https://docs.snowflake.com/en/sql-reference/constructs/group-by-rollup |
| HAVING | https://docs.snowflake.com/en/sql-reference/constructs/having |
| QUALIFY | https://docs.snowflake.com/en/sql-reference/constructs/qualify |
| ORDER BY | https://docs.snowflake.com/en/sql-reference/constructs/order-by |
| LIMIT | https://docs.snowflake.com/en/sql-reference/constructs/limit |
| FETCH | https://docs.snowflake.com/en/sql-reference/constructs/limit |
| FOR UPDATE | https://docs.snowflake.com/en/sql-reference/constructs/for-update |
| Query operators | https://docs.snowflake.com/en/sql-reference/operators |
| General DDL | https://docs.snowflake.com/en/sql-reference/sql-ddl-summary |
| General DML | https://docs.snowflake.com/en/sql-reference/sql-dml |
| All commands (alphabetical) | https://docs.snowflake.com/en/sql-reference/sql-all |
| Accounts | https://docs.snowflake.com/en/sql-reference/commands-account |
| Users, roles, & privileges | https://docs.snowflake.com/en/sql-reference/commands-user-role |
| Integrations | https://docs.snowflake.com/en/sql-reference/commands-integration |
| Business continuity & disaster recovery | https://docs.snowflake.com/en/sql-reference/commands-replication |
| Sessions | https://docs.snowflake.com/en/sql-reference/commands-session |
| Transactions | https://docs.snowflake.com/en/sql-reference/commands-transaction |
| Virtual warehouses & resource monitors | https://docs.snowflake.com/en/sql-reference/commands-warehouse |
| Databases, schemas, & shares | https://docs.snowflake.com/en/sql-reference/commands-database |
| Tables, views, sequences, and types | https://docs.snowflake.com/en/sql-reference/commands-table |
| Functions, procedures, & scripting | https://docs.snowflake.com/en/sql-reference/commands-function |
| Streams & tasks | https://docs.snowflake.com/en/sql-reference/commands-stream |
| DCM Projects | https://docs.snowflake.com/en/sql-reference/commands-dcm-projects |
| dbt Projects on Snowflake | https://docs.snowflake.com/en/sql-reference/commands-dbt-projects-on-snowflake |
| Classes & instances | https://docs.snowflake.com/en/sql-reference/commands-class |
| Machine learning | https://docs.snowflake.com/en/sql-reference/commands-ml |
| Cortex | https://docs.snowflake.com/en/sql-reference/commands-cortex |
| Listings | https://docs.snowflake.com/en/sql-reference/commands-listings |
| Openflow data plane integration | https://docs.snowflake.com/en/sql-reference/commands-ofdata-plane |
| Organization profiles | https://docs.snowflake.com/en/sql-reference/commands-organization-profiles |
| Security | https://docs.snowflake.com/en/sql-reference/commands-security |
| Data Governance | https://docs.snowflake.com/en/sql-reference/commands-data-governance |
| Privacy | https://docs.snowflake.com/en/sql-reference/commands-privacy |
| Data loading & unloading | https://docs.snowflake.com/en/sql-reference/commands-data-loading |
| File staging | https://docs.snowflake.com/en/sql-reference/commands-file |
| Storage lifecycle policies | https://docs.snowflake.com/en/sql-reference/commands-storage-lifecycle-policies |
| Git | https://docs.snowflake.com/en/sql-reference/commands-git |
| Alerts | https://docs.snowflake.com/en/sql-reference/commands-alert |
| Native Apps Framework | https://docs.snowflake.com/en/sql-reference/commands-native-apps |
| Snowflake App Runtime | https://docs.snowflake.com/en/sql-reference/commands-snowflake-apps |
| Streamlit | https://docs.snowflake.com/en/sql-reference/commands-streamlit |
| Notebook | https://docs.snowflake.com/en/sql-reference/commands-notebook |
| Snowpark Container Services | https://docs.snowflake.com/en/sql-reference/commands-snowpark-container-services |
| Snowflake Postgres | https://docs.snowflake.com/en/user-guide/snowflake-postgres/about |
| Function and stored procedure reference | https://docs.snowflake.com/en/sql-reference-functions |
| Class reference | https://docs.snowflake.com/en/sql-reference-classes |
| Scripting reference | https://docs.snowflake.com/en/sql-reference-snowflake-scripting |
| General reference | https://docs.snowflake.com/en/sql-reference |
| API reference | https://docs.snowflake.com/en/api-reference |
| Reference | https://docs.snowflake.com/en/reference |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Query syntax | https://docs.snowflake.com/en/sql-reference/constructs |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#select |
| Query syntax | https://docs.snowflake.com/sql-reference/constructs |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#syntax |
| Selecting all columns | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-syntax-all-columns |
| Selecting specific columns | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-syntax-selected-columns |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-specific-columns |
| Query syntax | https://docs.snowflake.com/sql-reference/constructs |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#parameters |
| TOP | https://docs.snowflake.com/sql-reference/constructs/top_n |
| FROM | https://docs.snowflake.com/sql-reference/constructs/from |
| DESCRIBE | https://docs.snowflake.com/sql-reference/sql/desc |
| FROM | https://docs.snowflake.com/sql-reference/constructs/from |
| FROM | https://docs.snowflake.com/sql-reference/constructs/from |
| Error case: Specifying an alias that matches another column name | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-matching-column-alias |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#usage-notes |
| Object identifiers | https://docs.snowflake.com/sql-reference/identifiers |
| subquery | https://docs.snowflake.com/user-guide/querying-subqueries |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#examples |
| Setting up the data for the examples | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-data-setup |
| Examples of selecting all columns (SELECT *) | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all |
| Examples of selecting specific columns (SELECT colname) | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-specific |
| Query syntax | https://docs.snowflake.com/sql-reference/constructs |
| Viewing log messages | https://docs.snowflake.com/developer-guide/logging-tracing/logging-accessing-messages |
| Viewing trace data | https://docs.snowflake.com/developer-guide/logging-tracing/tracing-accessing-events |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#setting-up-the-data-for-the-examples |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#examples-of-selecting-all-columns-select |
| Selecting all columns in the table | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table |
| Selecting all columns with names that match a pattern | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-matching |
| Selecting all columns except one column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-but-one |
| Selecting all columns except two or more columns | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-but-two |
| Selecting all columns and renaming one column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-rename-one |
| Selecting all columns and renaming multiple columns | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-rename-two |
| Selecting all columns with names that match a pattern and renaming a column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-matching-rename |
| Selecting all columns, excluding a column, and renaming multiple columns | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-exclude-rename |
| Selecting all columns and replacing the value of a column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-replace |
| Selecting all columns, replacing the value of a column, and renaming the column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-replace-rename |
| Selecting all columns with names that match a pattern and replacing the value in a column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-in-table-matching-replace |
| Selecting all columns from multiple tables, excluding a column, and renaming a column | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-all-multiple-tables |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-in-the-table |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-with-names-that-match-a-pattern |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-except-one-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-except-two-or-more-columns |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-and-renaming-one-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-and-renaming-multiple-columns |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-excluding-a-column-and-renaming-multiple-columns |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-with-names-that-match-a-pattern-and-renaming-a-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-and-replacing-the-value-of-a-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-replacing-the-value-of-a-column-and-renaming-the-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-with-names-that-match-a-pattern-and-replacing-the-value-in-a-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-all-columns-from-multiple-tables-excluding-a-column-and-renaming-a-column |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#examples-of-selecting-specific-columns-select-colname |
| Selecting a single column by name | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-specific-col-by-name |
| Selecting multiple columns by name from joined tables | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-specific-multiple-col-by-name |
| Selecting a column by position | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-specific-col-by-position |
| Specifying an alias for a column in the output | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-select-specific-col-alias |
| Error case: Specifying an alias that matches another column name | https://docs.snowflake.com/sql-reference/sql/select#label-select-cmd-examples-matching-column-alias |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-a-single-column-by-name |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-multiple-columns-by-name-from-joined-tables |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#selecting-a-column-by-position |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#specifying-an-alias-for-a-column-in-the-output |
| ¶ | https://docs.snowflake.com/sql-reference/sql/select#error-case-specifying-an-alias-that-matches-another-column-name |
| Visit Snowflake | https://www.snowflake.com |
| Join the conversation | https://community.snowflake.com/s/ |
| Develop with Snowflake | https://developers.snowflake.com |
| Share your feedback | https://docs.snowflake.com/feedback |
| Read the latest on our blog | https://www.snowflake.com/blog/ |
| Get your own certification | https://learn.snowflake.com |
| Privacy Notice | https://www.snowflake.com/privacy-policy/ |
| Site Terms | https://www.snowflake.com/legal/snowflake-site-terms/ |
| Snowflake Python APIs | https://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview |
| Snowflake REST APIs | https://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api |
| Snowflake CLI | https://docs.snowflake.com/developer-guide/snowflake-cli/index |
| Syntax | https://docs.snowflake.com/sql-reference/sql/select#syntax |
| Parameters | https://docs.snowflake.com/sql-reference/sql/select#parameters |
| Usage notes | https://docs.snowflake.com/sql-reference/sql/select#usage-notes |
| Examples | https://docs.snowflake.com/sql-reference/sql/select#examples |