Q. What is the purpose of the PIVOT operator in SQL?

A
Rotates rows to columns
B
Filters data
C
Aggregates data
D
Joins tables
Solution:

PIVOT rotates a table-valued expression by turning unique values from one column into multiple columns.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!