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
--u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=1) 

--select count(*) from Users

fork query

edited dec 26 12

created dec 25 12 anonymous