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 250
    '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')

Group By Posts.Id, Posts.Title, Posts.Body, Posts.CreationDate, Posts.Score, Posts.AnswerCount, Posts.CommentCount, Posts.FavoriteCount, Posts.ViewCount, Posts.AcceptedAnswerId, Posts.tags

Order By [ViewCount] Desc

Enter Parameters

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