[Solved] Which of the following is the correct syntax to use PIVOT in SQL? — Ans: SELECT * FROM table PIVOT (SUM(sales) FOR year IN (2019, 2020)); | SQL

SQL - Advanced Query Patterns

Which of the following is the correct syntax to use PIVOT in SQL?

ASELECT * FROM table UNPIVOT (SUM(sales) FOR year IN (2019, 2020));

BSELECT * FROM table WHERE PIVOT sales BY year;

CSELECT * FROM table PIVOT (SUM(sales) FOR year IN (2019, 2020));

DSELECT * FROM table GROUP BY PIVOT year;

Step-by-Step Solution

Solution:

Step 1: Review PIVOT syntax
The correct syntax uses PIVOT with an aggregate function and FOR ... IN clause listing values.
Step 2: Check options
SELECT * FROM table PIVOT (SUM(sales) FOR year IN (2019, 2020)); matches the correct syntax. Others misuse UNPIVOT or have invalid clauses.
Final Answer:
SELECT * FROM table PIVOT (SUM(sales) FOR year IN (2019, 2020)); -> Option C
Quick Check:
PIVOT syntax = SELECT * FROM table PIVOT (SUM(sales) FOR year IN (2019, 2020)); [OK]

Quick Trick: PIVOT uses FOR ... IN with aggregation [OK]

Common Mistakes:

Master "Advanced Query Patterns" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to use PIVOT in SQL?