Postgres max on few columns

Question

I have table, which looks like this

 id | item | price1 | price2

I want do get the list of items and for every item I want also to select max price among price1 and price2. Is it possible to do that in one query? Something like

SELECT item, max(price1,price2) FROM table;

UPDATE

Example:

table contains

item1 | 4 | 8
item2 | 5 | 1
item3 | 7 | 7

I want result to be

item1 | 8
item2 | 5
item3 | 7

Can you show what an example of what you expect the result to look like? — UsainBloot
– UsainBloot, Commented Jun 6, 2015 at 16:27
use max(price1), max(price2) a group by and a case statement to select the larger of the two as your the final output signal — amdixon
– amdixon, Commented Jun 6, 2015 at 16:28

Marth · Accepted Answer · 2015-06-06 16:39:38Z

1

Use GREATEST :

SELECT GREATEST(1, 100);
┌──────────┐
│ greatest │
├──────────┤
│      100 │
└──────────┘
(1 row)

answered Jun 6, 2015 at 16:39

Marth

24.9k3 gold badges68 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres max on few columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related