Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

--select top 10 * from posts answer
--inner join posts question
--on answer.parentid = question.id and question.parentid is not null 
--and answer.posttypeid = 2
--and ps.AcceptedAnswerId is not null
--where posttypeid = 2 


select top 10 parentid  from posts where id in (
SELECT a.parentid  FROM posts a
inner join posts question 
on a.parentid = question.id
where a.posttypeid = 2 and a.parentid is not null 
) and AcceptedAnswerId is not null

Enter Parameters

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