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.
Add a comment
|
2 Answers
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 :)
-
1Nice! And here is the same query just in descending order - note the data will be up to week old. Commented Jul 16, 2013 at 6:34
-
-
@Rishav: Not sure how the queries were changed. Anyway, I have updated both queries. You can check now. :)– HimanshuCommented 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?– RishavCommented May 21, 2018 at 5:41
-
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.
