SQL, "questions asked" ordered

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

Enter Parameters

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