0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created aug 20 15 anonymous