0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT top 2 '<h1>question: <h1>'+pa.body, '<h2>answer : <h2>'+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 desc

fork query

edited sep 18

created sep 18 anonymous