SELECT TOP 10 pq.Id as question_id, pa.Id as answer_id, p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

SELECT TOP 10 
pq.Id as question_id,
  pa.Id as answer_id,
  pa.ParentId as parent_id
FROM posts pq

LEFT JOIN 
  (
    SELECT * 
    FROM posts pa 
    WHERE pa.ParentId IS NOT NULL
  ) pa on pa.ParentId = pq.Id

WHERE pq.ParentId IS NULL

Enter Parameters

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