query question, get top python answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top(9) p.id as [Post Link], p2.score, p2.body from posts as p
join posts as p2 on p2.parentid = p.id
where p2.id in (
    select top(3) id
    from posts
    where posttypeid = 2 and parentid = p.id
    order by score desc
  )
  and p.title like '%open%file%'
  and p.answercount > 10
  and p.tags like '%python%'
  order by p.id asc, p2.score desc;

Enter Parameters

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