Home » MCQs » Transact-SQL (T-SQL) MCQs

Among PIVOT operators and UNPIVOT operators, which type of operator in T-SQL converts the row data into column data?

18. Among PIVOT operators and UNPIVOT operators, which type of operator in T-SQL converts the row data into column data?

1. PIVOT Operators.
2. UNPIVOT Operators.

Answer: A) PIVOT Operators.

Explanation:

PIVOT operator is the type of operator in T-SQL which converts the row data into column data.