SQL Transpose Rows as Columns

by

Use:

  SELECT r.user_id,
         MAX(CASE WHEN r.question_id = 1 THEN r.body ELSE NULL END) AS "Do you like apples?",
         MAX(CASE WHEN r.question_id = 2 THEN r.body ELSE NULL END) AS "Do you like oranges?",
         MAX(CASE WHEN r.question_id = 3 THEN r.body ELSE NULL END) AS "Do you like carrots?"
    FROM RESPONSES r
    JOIN QUESTIONS q ON q.id = r.question_id
GROUP BY r.user_id

This is a standard pivot query, because you are “pivoting” the data from rows to columnar data.

More Related Contents:

  1. PostgreSQL Crosstab Query
  2. Dynamic alternative to pivot with CASE and GROUP BY
  3. Pivot on Multiple Columns using Tablefunc
  4. TSQL Pivot without aggregate function
  5. Crosstab with a large or undefined number of categories
  6. Does PostgreSQL support “accent insensitive” collations?
  7. PostgreSQL: running count of rows for a query ‘by minute’
  8. Split comma separated column data into additional columns
  9. IN vs ANY operator in PostgreSQL
  10. How to delete duplicate entries?
  11. Escaping keyword-like column names in Postgres
  12. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  13. Pivoting data in MS Access
  14. GROUP BY + CASE statement
  15. Split column into multiple rows in Postgres
  16. Dynamic Oracle Pivot_In_Clause
  17. Getting date list in a range in PostgreSQL
  18. Postgres Dynamic Query Function
  19. How do I delete a fixed number of rows with sorting in PostgreSQL?
  20. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  21. Error: Column does not exist
  22. DROP FUNCTION without knowing the number/type of parameters?
  23. Multiple array_agg() calls in a single query
  24. PostgreSQL does not accept column alias in WHERE clause
  25. Postgres error updating column data
  26. Check whether string is a date Postgresql
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. Postgresql query between date ranges
  29. Why isn’t row level security enabled for Postgres views?
  30. Is there a postgres CLOSEST operator?

Leave a Comment