1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, students, teachers, and end users interested in bioinformatics

---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

fork query

created dec 16 18 Martin20528