Users who made the most recent posts


Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

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

  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

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