0

I have a table that has data similar to:

Date (date), Brand (text), Fruit (text), Quantity (integer), Price (numeric) '2016-03-19', Myers, Apple, 10000, 0.89

I have a query that returns a single row:

Select
    brand,
    fruit,
    quantity,
    price
from db.fruit
    where fruit = 'Apple

I'd like that to be output in the following format

Brand = Myers

Fruit = Apple

Quantity = 10000

Price = 0.89

Seems like this should be the opposite of what the crosstab function does.

jonnySQL
  • 77
  • 1
  • 5

0 Answers0