Explanation:
The correct answer is B (PIVOT). The PIVOT keyword in SQL is used to transform the rows of a table by rotating unique values of a specified column list into separate columns. This process effectively converts a table from a long format (where data is stored in rows) to a wide format (where data is stored in columns). This operation is commonly used in data analysis to summarize and present data more effectively.
Ultimate access to all questions.
No comments yet.
When working with SQL data transformations, which keyword is used specifically for converting a table from a long (tall) format, where each row represents a single observation, to a wide format, where each row contains multiple observations split across columns?
A
TRANSFORM
B
PIVOT
C
SUM
D
CONVERT
E
WHERE