Get Best Questions to remember

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT top 10 'question: '+pa.body, 'answer : '+a.body
  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 = 'angular' and
  pa.posttypeid = 1
  and a.posttypeid = 2
  
  
  
  --group by pa.id,pa.body,a.body,pa.posttypeid,pa.score,a.posttypeid
  order by pa.score,pa.FavoriteCount desc

Enter Parameters

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