3

On a particular Stack Exchange? I remember there being some site that could allow me to do that, but I don't remember where it was.

7

This query on http://data.stackexchange.com/ shows the top 100 users with the most questions.

0

If you're using raw SQL in offline dumps, Joachim's query (OwnerUserId as [User Link]) wouldn't automatically create a link to the user URL.

Instead, use this queryenter image description here:

declare @limit int=100;

select

    top(@limit)

    count(*)'Questions Asked',

    OwnerUserId,

    (select DisplayName from Users where Id=OwnerUserId)'Display Name',

    'https://stackoverflow.com/users/'+cast(OwnerUserId as varchar(100))'Text Link'

from Posts
where PostTypeId=1
group by OwnerUserId
order by 1 desc;

You must log in to answer this question.

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