Breaking News: Grepper is joining You.com. Read the official announcement!

Pivot query in miriadb

fa rnd2000 answered on September 26, 2022 Popularity 1/10 Helpfulness 1/10

answer Pivot query in miriadb

Pivot query in miriadb

Comment

SELECT
  user_id,
  MAX(CASE WHEN name = "foo" THEN value END) "foo",
  MAX(CASE WHEN name = "bar" THEN value END) "bar",
  MAX(CASE WHEN name = "baz" THEN value END) "baz",
  MAX(CASE WHEN name = "quux" THEN value END) "quux",
  MAX(CASE WHEN name = "waldo" THEN value END) "waldo"
FROM table
GROUP BY user_id
ORDER BY user_id ASC

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: pivot whatever

Link to this answer
Share Copy Link