Get all the users related to a single post Id

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

declare @postId as int
set @postId = 2512683;

select * from 
( select OwnerUserId from Posts where Id = @postId 
union
select OwnerUserId from Posts where ParentId = @postId) x
inner join 
Users y
on x.OwnerUserId = y.id

Enter Parameters

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