René's URL Explorer Experiment


Title: PIVOT | Snowflake Documentation

direct link

Domain: docs.snowflake.com

Links:

DOCUMENTATIONhttps://docs.snowflake.com
Englishhttps://docs.snowflake.com/en/sql-reference/constructs/pivot
Françaishttps://docs.snowflake.com/fr/sql-reference/constructs/pivot
Deutschhttps://docs.snowflake.com/de/sql-reference/constructs/pivot
日本語https://docs.snowflake.com/ja/sql-reference/constructs/pivot
한국어https://docs.snowflake.com/ko/sql-reference/constructs/pivot
Portuguêshttps://docs.snowflake.com/pt/sql-reference/constructs/pivot
Get startedhttps://docs.snowflake.com/en/user-guide-getting-started
Guideshttps://docs.snowflake.com/en/guides
Developerhttps://docs.snowflake.com/en/developer
Referencehttps://docs.snowflake.com/en/reference
Release noteshttps://docs.snowflake.com/en/release-notes/overview
Tutorialshttps://docs.snowflake.com/en/tutorials
Statushttps://status.snowflake.com
Overviewhttps://docs.snowflake.com/en/reference
SQL data types referencehttps://docs.snowflake.com/en/sql-reference-data-types
SQL command referencehttps://docs.snowflake.com/en/sql-reference-commands
Query syntaxhttps://docs.snowflake.com/en/sql-reference/constructs
SELECThttps://docs.snowflake.com/en/sql-reference/sql/select
WITHhttps://docs.snowflake.com/en/sql-reference/constructs/with
TOP https://docs.snowflake.com/en/sql-reference/constructs/top_n
INTOhttps://docs.snowflake.com/en/sql-reference/constructs/into
FROMhttps://docs.snowflake.com/en/sql-reference/constructs/from
AThttps://docs.snowflake.com/en/sql-reference/constructs/at-before
BEFOREhttps://docs.snowflake.com/en/sql-reference/constructs/at-before
CHANGEShttps://docs.snowflake.com/en/sql-reference/constructs/changes
CONNECT BYhttps://docs.snowflake.com/en/sql-reference/constructs/connect-by
JOINhttps://docs.snowflake.com/en/sql-reference/constructs/join
ASOF JOINhttps://docs.snowflake.com/en/sql-reference/constructs/asof-join
LATERALhttps://docs.snowflake.com/en/sql-reference/constructs/join-lateral
MATCH_RECOGNIZEhttps://docs.snowflake.com/en/sql-reference/constructs/match_recognize
PIVOThttps://docs.snowflake.com/en/sql-reference/constructs/pivot
UNPIVOThttps://docs.snowflake.com/en/sql-reference/constructs/unpivot
VALUEShttps://docs.snowflake.com/en/sql-reference/constructs/values
SAMPLE / TABLESAMPLEhttps://docs.snowflake.com/en/sql-reference/constructs/sample
RESAMPLEhttps://docs.snowflake.com/en/sql-reference/constructs/resample
SEMANTIC_VIEWhttps://docs.snowflake.com/en/sql-reference/constructs/semantic_view
WHEREhttps://docs.snowflake.com/en/sql-reference/constructs/where
GROUP BYhttps://docs.snowflake.com/en/sql-reference/constructs/group-by
GROUP BY CUBEhttps://docs.snowflake.com/en/sql-reference/constructs/group-by-cube
GROUP BY GROUPING SETShttps://docs.snowflake.com/en/sql-reference/constructs/group-by-grouping-sets
GROUP BY ROLLUPhttps://docs.snowflake.com/en/sql-reference/constructs/group-by-rollup
HAVINGhttps://docs.snowflake.com/en/sql-reference/constructs/having
QUALIFYhttps://docs.snowflake.com/en/sql-reference/constructs/qualify
ORDER BYhttps://docs.snowflake.com/en/sql-reference/constructs/order-by
LIMIThttps://docs.snowflake.com/en/sql-reference/constructs/limit
FETCHhttps://docs.snowflake.com/en/sql-reference/constructs/limit
FOR UPDATEhttps://docs.snowflake.com/en/sql-reference/constructs/for-update
Query operatorshttps://docs.snowflake.com/en/sql-reference/operators
General DDLhttps://docs.snowflake.com/en/sql-reference/sql-ddl-summary
General DMLhttps://docs.snowflake.com/en/sql-reference/sql-dml
All commands (alphabetical)https://docs.snowflake.com/en/sql-reference/sql-all
Accountshttps://docs.snowflake.com/en/sql-reference/commands-account
Users, roles, & privilegeshttps://docs.snowflake.com/en/sql-reference/commands-user-role
Integrationshttps://docs.snowflake.com/en/sql-reference/commands-integration
Business continuity & disaster recoveryhttps://docs.snowflake.com/en/sql-reference/commands-replication
Sessionshttps://docs.snowflake.com/en/sql-reference/commands-session
Transactionshttps://docs.snowflake.com/en/sql-reference/commands-transaction
Virtual warehouses & resource monitorshttps://docs.snowflake.com/en/sql-reference/commands-warehouse
Databases, schemas, & shareshttps://docs.snowflake.com/en/sql-reference/commands-database
Tables, views, sequences, and typeshttps://docs.snowflake.com/en/sql-reference/commands-table
Functions, procedures, & scriptinghttps://docs.snowflake.com/en/sql-reference/commands-function
Streams & taskshttps://docs.snowflake.com/en/sql-reference/commands-stream
DCM Projectshttps://docs.snowflake.com/en/sql-reference/commands-dcm-projects
dbt Projects on Snowflakehttps://docs.snowflake.com/en/sql-reference/commands-dbt-projects-on-snowflake
Classes & instanceshttps://docs.snowflake.com/en/sql-reference/commands-class
Machine learninghttps://docs.snowflake.com/en/sql-reference/commands-ml
Cortexhttps://docs.snowflake.com/en/sql-reference/commands-cortex
Listingshttps://docs.snowflake.com/en/sql-reference/commands-listings
Openflow data plane integrationhttps://docs.snowflake.com/en/sql-reference/commands-ofdata-plane
Organization profileshttps://docs.snowflake.com/en/sql-reference/commands-organization-profiles
Securityhttps://docs.snowflake.com/en/sql-reference/commands-security
Data Governancehttps://docs.snowflake.com/en/sql-reference/commands-data-governance
Privacyhttps://docs.snowflake.com/en/sql-reference/commands-privacy
Data loading & unloadinghttps://docs.snowflake.com/en/sql-reference/commands-data-loading
File staginghttps://docs.snowflake.com/en/sql-reference/commands-file
Storage lifecycle policieshttps://docs.snowflake.com/en/sql-reference/commands-storage-lifecycle-policies
Githttps://docs.snowflake.com/en/sql-reference/commands-git
Alertshttps://docs.snowflake.com/en/sql-reference/commands-alert
Native Apps Frameworkhttps://docs.snowflake.com/en/sql-reference/commands-native-apps
Snowflake App Runtimehttps://docs.snowflake.com/en/sql-reference/commands-snowflake-apps
Streamlithttps://docs.snowflake.com/en/sql-reference/commands-streamlit
Notebookhttps://docs.snowflake.com/en/sql-reference/commands-notebook
Snowpark Container Serviceshttps://docs.snowflake.com/en/sql-reference/commands-snowpark-container-services
Snowflake Postgreshttps://docs.snowflake.com/en/user-guide/snowflake-postgres/about
Function and stored procedure referencehttps://docs.snowflake.com/en/sql-reference-functions
Class referencehttps://docs.snowflake.com/en/sql-reference-classes
Scripting referencehttps://docs.snowflake.com/en/sql-reference-snowflake-scripting
General referencehttps://docs.snowflake.com/en/sql-reference
API referencehttps://docs.snowflake.com/en/api-reference
Referencehttps://docs.snowflake.com/en/reference
SQL command referencehttps://docs.snowflake.com/en/sql-reference-commands
Query syntaxhttps://docs.snowflake.com/en/sql-reference/constructs
Query syntaxhttps://docs.snowflake.com/sql-reference/constructs
https://docs.snowflake.com/sql-reference/constructs/pivot#pivot
FROMhttps://docs.snowflake.com/sql-reference/constructs/from
built-in aggregate functionshttps://docs.snowflake.com/sql-reference/functions-aggregation
AVGhttps://docs.snowflake.com/sql-reference/functions/avg
COUNThttps://docs.snowflake.com/sql-reference/functions/count
MAXhttps://docs.snowflake.com/sql-reference/functions/max
MINhttps://docs.snowflake.com/sql-reference/functions/min
SUMhttps://docs.snowflake.com/sql-reference/functions/sum
UNPIVOThttps://docs.snowflake.com/sql-reference/constructs/unpivot
https://docs.snowflake.com/sql-reference/constructs/pivot#syntax
https://docs.snowflake.com/sql-reference/constructs/pivot#parameters
ORDER BYhttps://docs.snowflake.com/sql-reference/constructs/order-by
Working with Subquerieshttps://docs.snowflake.com/user-guide/querying-subqueries
https://docs.snowflake.com/sql-reference/constructs/pivot#usage-notes
viewhttps://docs.snowflake.com/user-guide/views-introduction
CASThttps://docs.snowflake.com/sql-reference/functions/cast
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
UNION operatorhttps://docs.snowflake.com/sql-reference/operators-query#label-query-operators-union
Dynamic pivot with multiple aggregations using UNIONhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-multiple-aggregations
https://docs.snowflake.com/sql-reference/constructs/pivot#examples
Dynamic pivot on all distinct column values automaticallyhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-dynamic
Dynamic pivot on column values using a subqueryhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-subquery
Dynamic pivot with multiple aggregations using UNIONhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-multiple-aggregations
Dynamic pivot with a join queryhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-join
Pivot on a specified list of column values for the pivot columnhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-column-list
Pivot with a default value for NULL valueshttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-default-on-nulls
Pivot examples that involve multiple columnshttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-multiple-columns
https://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-on-all-distinct-column-values-automatically
https://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-on-column-values-using-a-subquery
https://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-with-multiple-aggregations-using-union
UNION operatorhttps://docs.snowflake.com/sql-reference/operators-query#label-query-operators-union
AVGhttps://docs.snowflake.com/sql-reference/functions/avg
MAXhttps://docs.snowflake.com/sql-reference/functions/max
MINhttps://docs.snowflake.com/sql-reference/functions/min
COUNThttps://docs.snowflake.com/sql-reference/functions/count
SUMhttps://docs.snowflake.com/sql-reference/functions/sum
https://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-with-a-join-query
common table expression (CTE)https://docs.snowflake.com/user-guide/queries-cte
https://docs.snowflake.com/sql-reference/constructs/pivot#pivot-on-a-specified-list-of-column-values-for-the-pivot-column
https://docs.snowflake.com/sql-reference/constructs/pivot#pivot-with-a-default-value-for-null-values
https://docs.snowflake.com/sql-reference/constructs/pivot#pivot-examples-that-involve-multiple-columns
Exclude columns from a pivot query with a CTEhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-multiple-columns-exclude
Run a multidimensional pivot queryhttps://docs.snowflake.com/sql-reference/constructs/pivot#label-pivot-example-multiple-columns-multidimensional
https://docs.snowflake.com/sql-reference/constructs/pivot#exclude-columns-from-a-pivot-query-with-a-cte
common table expression (CTE)https://docs.snowflake.com/user-guide/queries-cte
https://docs.snowflake.com/sql-reference/constructs/pivot#run-a-multidimensional-pivot-query
SUMhttps://docs.snowflake.com/sql-reference/functions/sum
MAXhttps://docs.snowflake.com/sql-reference/functions/max
Visit Snowflakehttps://www.snowflake.com
Join the conversationhttps://community.snowflake.com/s/
Develop with Snowflakehttps://developers.snowflake.com
Share your feedbackhttps://docs.snowflake.com/feedback
Read the latest on our bloghttps://www.snowflake.com/blog/
Get your own certificationhttps://learn.snowflake.com
Privacy Noticehttps://www.snowflake.com/privacy-policy/
Site Termshttps://www.snowflake.com/legal/snowflake-site-terms/
Snowflake Python APIshttps://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview
Snowflake REST APIshttps://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api
Snowflake CLIhttps://docs.snowflake.com/developer-guide/snowflake-cli/index
Syntaxhttps://docs.snowflake.com/sql-reference/constructs/pivot#syntax
Parametershttps://docs.snowflake.com/sql-reference/constructs/pivot#parameters
Usage noteshttps://docs.snowflake.com/sql-reference/constructs/pivot#usage-notes
Exampleshttps://docs.snowflake.com/sql-reference/constructs/pivot#examples
Dynamic pivot on all distinct column values automaticallyhttps://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-on-all-distinct-column-values-automatically
Dynamic pivot on column values using a subqueryhttps://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-on-column-values-using-a-subquery
Dynamic pivot with multiple aggregations using UNIONhttps://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-with-multiple-aggregations-using-union
Dynamic pivot with a join queryhttps://docs.snowflake.com/sql-reference/constructs/pivot#dynamic-pivot-with-a-join-query
Pivot on a specified list of column values for the pivot columnhttps://docs.snowflake.com/sql-reference/constructs/pivot#pivot-on-a-specified-list-of-column-values-for-the-pivot-column
Pivot with a default value for NULL valueshttps://docs.snowflake.com/sql-reference/constructs/pivot#pivot-with-a-default-value-for-null-values
Pivot examples that involve multiple columnshttps://docs.snowflake.com/sql-reference/constructs/pivot#pivot-examples-that-involve-multiple-columns

Viewport: width=device-width

URLs of crawlers that visited me.