SELECT TOP 100 p.Id, p.ParentId, p.AcceptedAnswerId, p.Cr...

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 100
  p.Id,
  p.ParentId,
  p.AcceptedAnswerId,
  p.CreationDate
FROM 

(
  SELECT 
    pq.Id, 
    pq.ParentId, 
    pq.AcceptedAnswerId, 
    pq.CreationDate 
  FROM posts pq
  LEFT JOIN (
    SELECT 
      pa.Id, 
      pa.ParentId, 
      pa.AcceptedAnswerId, 
      pa.CreationDate 
    FROM posts as pa 
    WHERE pa.ParentId IS NOT NULL
  ) pa on pa.ParentId = pq.Id
) as p
  
order by id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results