User's first questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

with firstpostids_cte as (
SELECT MIN(Id) AS MinId, OwnerUserId
FROM Posts
WHERE PostTypeId=1
GROUP BY OwnerUserId
)

SELECT Top 100
p.Id AS [Post Link], p.OwnerUserId AS [User Link], p.CreationDate, p.ClosedDate
FROM firstpostids_cte fp JOIN Posts p ON fp.MinId=p.Id
ORDER BY p.CreationDate DESC

Enter Parameters

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