🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: SQL for Data Analysis: all 9 questions

Quiz: SQL for Data Analysis · Question 4 of 9

Which operation turns columns back into rows?

Which operation turns columns back into rows?

  1. A.GROUP BY
  2. B.INNER JOIN
  3. C.ORDER BY
  4. D.UNION ALL of one SELECT per column (unpivot)
Answer & explanation

Correct answer: UNION ALL of one SELECT per column (unpivot)

Each SELECT outputs one former column as rows, and UNION ALL stacks them.

Can you get the rest right without peeking?

Take the timed Quiz: SQL for Data Analysis quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →