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?
- PIVOT Operators.
- 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.