postgres query count characters and order by longest length

Question

I'm using the following query to print all title from stories table

select title from stories;

which show me all titles , The point here how to tweak it and do the following :

`order by longest title or even count longest title`

any tips

select title from stories order by char_length(title) desc? — user330315
– user330315, Commented Apr 2, 2014 at 7:13

user sflskjdf · Accepted Answer · 2014-04-02 09:08:34Z

53

If you to order by the length of the title (longest to shortest) you should use the following query

select title from stories order by length(title) desc

answered Apr 2, 2014 at 9:08

user sflskjdf

5746 silver badges10 bronze badges

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

1 Answer 1