1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

-- Select * from PostTypes
-- Result: 
-- 1 Question
-- 2 Answer
-- 3 Wiki
-- 4 TagWikiExcerpt
-- 5 TagWiki
-- 6 ModeratorNomination
-- 7 WikiPlaceholder
-- 8 PrivilegeWiki

Select Top 10 * from Posts
Where (
        PostTypeId = 1 --question type
     or PostTypeId = 2 --answer type
     )
    and OwnerUserId is null
order by CreationDate Desc

fork query

created may 2 18 Behzad.Khosravifar