select q.* from Posts as a inner join Posts as q on q.Id...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

-- Enter Query Title
-- Enter Query Description

select 
    q.* 
from 
    Posts as a
        inner join Posts as q on q.Id = a.ParentId
where
    --- Post type answer.
    a.PostTypeId = 2 and
    --- User casperOne
    a.OwnerUserId = 50776 and
    --- No other answers
    not exists (
        select * from Posts where ParentId = q.Id and Id <> a.Id
    )

Enter Parameters

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