;with allusers as ( select id , creationdate , (select mi...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production

Q&A for engineers, producers, editors, and enthusiasts spanning the fields of audio, video, and media creation

;with allusers as (
select id
     , creationdate
     , (select min(id) id from Users where id > u.id) nid
from users u
where id > 0
)
SELECT TOP 100 
  curr.id as [User Link]
, curr.id
, curr.creationdate
, next.id
, next.creationdate
, next.id as [User Link]
From AllUsers curr
inner join allusers next on curr.nid = next.id
where curr.creationdate > next.creationdate

ORDER BY curr.creationdate

Enter Parameters

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