Re: Split the result of a query in 2 rows - Mailing list pgsql-novice

From David G Johnston
Subject Re: Split the result of a query in 2 rows
Date
Msg-id 1425494805753-5840502.post@n5.nabble.com
Whole thread Raw
In response to Split the result of a query in 2 rows  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Responses Re: Split the result of a query in 2 rows
List pgsql-novice
JORGE MALDONADO wrote
> I have a very simple query to a single table as follows:
>
> SELECT field1, field2 FROM tbl_table ORDER BY field1
>
> Is it possible to "split" the results so field1 is displayed in one row
> and
> field2 in another row?
>
> Best regards,
> Jorge Maldonado

See "UNION ALL"

David J.




--
View this message in context: http://postgresql.nabble.com/Split-the-result-of-a-query-in-2-rows-tp5840497p5840502.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Split the result of a query in 2 rows
Next
From: Yaser Raja
Date:
Subject: Re: Split the result of a query in 2 rows