TWO RESULTS in SAME ROW in POSTGRESQL

Question

select * from Table1 where Condition 1 union select select * from Table1 where Condition 2

RESULTS:

NAME AMOUNT TYPE ABC -- Account ABC 200 --

but i need the results in one row like

NAME AMOUNT TYPE ABC 200 ACCOUNT

How to do in PG?

What you want is a JOIN not a UNION

jmoerdyk
– jmoerdyk

2017-08-29 17:53:04 +00:00
Commented Aug 29, 2017 at 17:53 — jmoerdyk
– jmoerdyk, Commented Aug 29, 2017 at 17:53

Ferdinand Gaspar · Accepted Answer · 2017-08-29 20:11:36Z

Base on your sample data, this may work

SELECT name, MAX(amount) amount, MAX(type) type FROM table1 WHERE condition 1 OR condition 2 GROUP BY name

Danielson Alves Júnior · Accepted Answer · 2018-10-22 19:02:27Z

I've achieved something like that with the following:

select TABLE_1.DESCRIPTION_COLUMN, (array(select TABLE_2.INFO_COLUMN from TABLE_2 where TABLE_1.ID = TABLE_2.ID_TABLE_1))[1], (array(select TABLE_2.INFO_COLUMN from TABLE_2 where TABLE_1.ID = TABLE_2.ID_TABLE_1))[2] from TABLE_1 WHERE TABLE_1 = 1

Source/Help:

https://stackoverflow.com/a/6402163/1856745

Collectives™ on Stack Overflow

TWO RESULTS in SAME ROW in POSTGRESQL

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related