SET STATISTICS IO ON SELECT Title, CreationDate, OwnerDi...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- select all questions for which there is not any question with a 
-- higher score

SET STATISTICS IO ON SELECT Title, CreationDate, OwnerDisplayName
FROM Posts AS P1
WHERE NOT EXISTS (
  SELECT * FROM Posts AS P2
  WHERE PostTypeId = 1 AND P2.Score > P1.Score
  );

Enter Parameters

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