6

I want to find the list of questions on a site that have the longest titles.

The purpose is testing design elements that might break or have layout problems if the title is too long. It's also an interesting query by itself, but searching visually through the questions listing is just too frustrating.

Improve this question
4
  • Longest titles by character count or width?
    – Laurel
    Commented Jun 26, 2022 at 23:38
  • @Laurel what do you mean by width? the data-explorer only knows character counts since the rendering is done by the browser client-side and depends on your fonts, etc...
    – bad_coder
    Commented Jun 26, 2022 at 23:39
  • 3
    A long time ago, the title character limit used to be 250 instead of 150, so you might find some posts that use longer titles from the time they were allowed.
    – Sonic the Anonymous Hedgehog
    Commented Jun 26, 2022 at 23:51
  • 1
    Note that sometimes question titles with MathJax formula may cause issues meta.stackexchange.com/q/378009/178179
    – Franck Dernoncourt
    Commented Jun 28, 2022 at 8:31

1 Answer 1

Reset to default
8

Here's your query. You can adjust the number in SELECT TOP 100 to change the number of rows returned. Note that the ordering among posts tied for title length is arbitrary, and changes from execution to execution.

SQL:

SELECT TOP 100 Id as [Post Link], Title
FROM Posts
ORDER BY LEN(Posts.Title) DESC
Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .