user's top 10 longest post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select top ##Top:int?10## id, len(body) as [Length], id as [Post Link]
from posts
where owneruserid=##UserID##
order by len(body) desc

--Top:Top How Many?
--userID:Numeric User ID:

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results