Highlander badge

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for database professionals who wish to improve their database skills and learn from others in the community

select
 p.OwnerUserId as [User Link],
 p.Id as [Post Link],
 p.Score
from Posts p
inner join Posts q on q.Id = p.ParentID
where p.PostTypeId = 2 and p.Score > 5
and q.Score > 3 and q.AnswerCount = 1
and q.AcceptedAnswerId = p.Id

created jul 31 10

Simon Brown

Enter Parameters

Options: Text-only results Include execution plan

Hold tight while we fetch your results

Results Messages Graph Execution Plan

Download CSV Download XML

:records rows returned in :time ms:cached

Highlander badge

Please login or register to vote for this query.

Enter Parameters

To avoid spam queries, all anonymous users must solve a captcha