Declare @PostId TABLE ( ID int ) insert into @PostID val...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

-- Enter Query Title
-- Enter Query Description
Declare @PostId TABLE (
ID int

)
insert into @PostID values (234)
insert into @PostID values (1234)
select Posts.score,Posts.Id, Posts.Body, Posts.ParentId from Posts
where posts.ParentId in (select Id from @postid) and posts.PostTypeId = 2
order by Posts.Score desc, Posts.ParentId desc
--Limit 0,4;

Enter Parameters

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