SET STATISTICS IO ON; SELECT Title, CreationDate, OwnerD...

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