0

Please login or register to vote for this query.

(click on this box to dismiss)

Maybe a different cutoff value for the number of posts or a changed ordering would be preferable.

Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools

select top 100
    posts.Id, posts.OwnerUserId, users.Reputation, posts.Title, posts.Tags, 
    posts.CreationDate
  from
    posts 
    inner join users on users.Id = posts.OwnerUserId
  where posts.PostTypeId = 1 -- answers

order by posts.CreationDate desc

fork query

edited aug 29 16 anonymous

created jul 14 10 sth