Shortest posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology

Q&A for enthusiasts and scholars of mythology and folklore

select u.id, u.displayname, p.id, p.body, p.creationdate
  from ( select top 10 id, body, creationdate, owneruserid
           from posts
          where posttypeid = 2
           order by len(body) asc ) p
  join users u
    on p.owneruserid = u.id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results