DEA-C01 · Question #77
Pivoting in SQL is mainly used to transform data from:
The correct answer is D. Multiple rows into multiple columns. Pivoting in SQL transforms data by rotating rows into columns, allowing for a more concise and summarized view of the data.
Question
Pivoting in SQL is mainly used to transform data from:
Options
- AOne row to one column
- BOnly one column to one row
- CMultiple columns into multiple rows
- DMultiple rows into multiple columns
How the community answered
(31 responses)- A3% (1)
- C3% (1)
- D94% (29)
Why each option
Pivoting in SQL transforms data by rotating rows into columns, allowing for a more concise and summarized view of the data.
Transforming one row to one column is not the primary function of pivoting; pivoting typically aggregates and spreads data.
Transforming one column to one row is more akin to unpivoting or simple selection, not pivoting.
Transforming multiple columns into multiple rows is characteristic of an UNPIVOT operation, which is the opposite of pivoting.
The PIVOT operator in SQL takes unique values from one column (the pivoting column) and turns them into separate columns in the result set, effectively transforming multiple rows of data into a single row with multiple columns for aggregation or easier analysis. This is particularly useful for summarizing data by categories that become new columns.
Concept tested: SQL PIVOT operation
Source: https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.