4

Is there a way to sort the users by their joining date? So that I can see who is the oldest user and also who is the latest user.

2 Answers 2

10

Here you go using Data.SE

SELECT TOP ##Top## ID AS [User Link], Reputation
              , CreationDate, LastAccessDate, Location
  FROM Users
 ORDER BY CreationDate

For the latest users just order the records in descending order instead of ascending order.

ORDER BY CreationDate DESC

Note that data in Data.SE is updated weekly So the latest users will be at least one week old. However it won't affect the oldest users :)

5
  • 1
    Nice! And here is the same query just in descending order - note the data will be up to week old. Jul 16, 2013 at 6:34
  • For some reason I dont see any result. Its just blank.
    – Rishav
    May 20, 2018 at 10:57
  • @Rishav: Not sure how the queries were changed. Anyway, I have updated both queries. You can check now. :)
    – Himanshu
    May 21, 2018 at 4:43
  • @hims056 Yea that works now. Thanks. I wonder why one of the co-founders cum member is not on the top?
    – Rishav
    May 21, 2018 at 5:41
  • @Rishav: Jeff Atwood is co-founder of Stack Overflow.
    – Himanshu
    May 21, 2018 at 7:28
0

AFAIK, such feature is not available for normal users. May be data.stackexchange.com help you to finding users by joining date.

Each user has given a unique user Id, based on this Id you can differentiate between two or more users that which user has joined site first.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .