0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- select questions where the score is the maximum for any question.

SET STATISTICS IO ON SELECT Title, CreationDate, OwnerDisplayName
FROM Posts
WHERE PostTypeId = 1 AND
  Score = (SELECT MAX(Score) FROM Posts WHERE PostTypeId = 1);

fork query

created dec 13 23 jon.doe42973