Which SQL feature allows you to pivot rows into columns dynamically without hardcoding column names?
SQL Data AnalystHard
SQL Data Analyst — Hard
Which SQL feature allows you to pivot rows into columns dynamically without hardcoding column names?
Explanation
Static PIVOT requires hardcoded column values; dynamic SQL constructs the PIVOT statement at runtime by first querying the distinct values to use as column headers.
