Most popular questions from last week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

select top 50
    'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link], 
    Posts.Title,
    Posts.CreationDate,
    Posts.AnswerCount,
    Posts.CommentCount,
    Posts.FavoriteCount,
    Posts.ViewCount,
    Posts.Tags [Tags]
FROM Tags    
    JOIN PostTags ON PostTags.TagId = Tags.Id
    JOIN Posts ON Posts.Id = PostTags.PostId 
WHERE    
Posts.PostTypeId=1
and Posts.CreationDate > DATEADD(DAY, -7, GETDATE())
and Tags.TagName = 'java'

Order By [ViewCount] Desc

Enter Parameters

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