0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 31 19

created jan 8 19 anonymous