Postgres selecting distinct value from one column and insert into table

Question

I am not able to select distinct store_id from the table in postgres..

vignesh ramanathan · Accepted Answer · 2017-03-09 08:54:54Z

2

Your syntax is wrong - try using DISTINCT ON (more info here)

If you want to maintain the column order you can do a nested select

411 gold badge2 silver badges7 bronze badges

answered Mar 7, 2017 at 11:28

paqash

2,3141 gold badge20 silver badges22 bronze badges

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

2 Comments

There, try that

Any luck with that?