Get Best Questions to remember

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

SELECT top 2 '<h4>question: '+pa.body+'</h4>', '<h2>answer : <h5>'+a.body+'</h5>'
  FROM dbo.Posts AS pa
   inner join posts a on pa.acceptedanswerid = a.id
  INNER JOIN dbo.PostTags AS pta
    ON pa.Id = pta.PostId
  INNER JOIN dbo.Tags AS ta
    ON ta.Id = pta.TagId
  WHERE ta.TagName = '##tag##' and
  pa.posttypeid = 1
  and a.posttypeid = 2
 order by pa.score desc

Enter Parameters

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