Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
In the context of transforming data in SQL, especially when dealing with data analysis tasks, one often needs to reshape data from a long format (where each row represents an observation) to a wide format (where each row represents an entity and columns represent different attributes of that entity). Which SQL keyword can be used to achieve this transformation?
In the context of transforming data in SQL, especially when dealing with data analysis tasks, one often needs to reshape data from a long format (where each row represents an observation) to a wide format (where each row represents an entity and columns represent different attributes of that entity). Which SQL keyword can be used to achieve this transformation?
Exam-Like