closed users who stayed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select * from posts p1
inner join (select owneruserid, min(id) as id from posts p2 where p2.closeddate is not null group by owneruserid) p3
on p3.owneruserid = p1.owneruserid and p3.id <> p1.id

Enter Parameters

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