postgresql - getting an ordered array from table

Question

for a table like this

id|col
1 |a
2 |b
3 |a

I would like to get an array of just col elements ordered by how often they appear in the table. how can this be done?

Juan Carlos Oropeza · Accepted Answer · 2019-06-17 09:06:42Z

2

SELECT ARRAY(SELECT col
             FROM yourTable
             GROUP BY col
             ORDER BY COUNT(*) );

answered Jun 17, 2019 at 9:06

48.4k14 gold badges87 silver badges128 bronze badges

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

1 Comment

ORDER BY COUNT(*) DESC may be