users

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

WITH questionsWithAnswers AS(
  SELECT
    AcceptedAnswerId
  FROM
    Posts
  WHERE
    PostTypeId = 1
    AND AcceptedAnswerId IS NOT NULL
)
SELECT
  top 100
  p.Id,
  p.Score,
  p.ViewCount,
  p.OwnerUserId,
  p.CommentCount,
  p.FavoriteCount,
(CASE WHEN EXISTS(SELECT 1 FROM questionsWithAnswers qa WHERE qa.AcceptedAnswerId = p.id)
    THEN 1
    ELSE 0 
  END) AS IsAcceptedAnswer
from posts p
where postTypeId = 2

Enter Parameters

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