Extracting top records with highest viewcount in descending order & get username from user table

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing

Q&A for practitioners of the art and science of signal, image and video processing

SELECT top 50000 posts.Id,posts.Score,posts.ViewCount,posts.OwnerUserId,posts.OwnerDisplayName,posts.Title,posts.Body,posts.Tags, 
Users.Id, Users.DisplayName
FROM posts
LEFT JOIN Users ON posts.OwnerUserId = Users.Id
where posts.ViewCount <= 10062790
ORDER BY posts.ViewCount desc;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results