Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

with optjava as (
Select PostId
from PostTags
where TagId = 5 or TagId = 42
group by PostId
having count(*) = 2)
select id as [Post Link],
       AcceptedAnswerId,
       Score,
       CreationDate,
       AnswerCount
from Posts inner join optjava on Id = PostId
where ClosedDate is null
  and Score > 0
order by Score Desc

Enter Parameters

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