0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and scholars of mythology and folklore

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

fork query

edited mar 2 13 anonymous

created feb 25 13 mauricio.verado