0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for network engineers

--select OwnerDisplayName from Posts where OwnerUserId is null group by OwnerDisplayName

--select * from Users order by Reputation asc

--select Id, PostTypeId, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, OwnerUserId, OwnerDisplayName, LastEditorUserId
--, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount,FavoriteCount, ClosedDate, CommunityOwnedDate 
--from Posts 
--where PostTypeId=2 order by Score asc

--select * from Users u where 
--u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=1) 
--and
--u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=2) 

select count(*) as total from Posts p where 
exists   
(select u.Id from Users u where 
u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=1) 
and
u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=2) 
and u.Id=p.OwnerUserId
) 
--group by p.OwnerUserId

fork query

edited dec 26 12

created dec 25 12 anonymous