Q&A for scientists using computers to solve scientific problems
SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM posts aa WHERE aa.AcceptedAnswerId = p.id) THEN 1 ELSE 0 END) AS IsAcceptedAnswer from posts p where postTypeId = 2 and id = 100000 --select * from posttypes -- 1 = question -- 2 = answer