Users who made the most recent posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

---Date is restricted so that the query is not too slow (with too many results)
;with recent_cte AS
(
SELECT
  OwnerUserId AS uid,
  MAX(Id) AS MaxId
FROM Posts
WHERE (CreationDate>='##datemin?2018-01-01##')
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