Users who made the most recent posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

;with recent_cte AS
(
SELECT
  OwnerUserId AS uid,
  MAX(Id) AS MaxId
FROM Posts
GROUP BY OwnerUserId
)

SELECT
  uid AS [User Link], p.CreationDate, MaxId [Post Link], p.Score
FROM recent_cte inner JOIN Posts p ON MaxId = p.Id
ORDER BY p.CreationDate DESC

Enter Parameters

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