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

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

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

1. PIVOT Operators.
2. UNPIVOT Operators.

Answer: B) UNPIVOT Operators.

Explanation:

UNPIVOT operators are the type of operator in T-SQL which Converts column-based data into row-based data and vice versa.