0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to improve their interpersonal communication skills

SELECT TOP 20 
    Id AS [Post ID],
    Title,
    CreationDate AS [Date Created],
    Score,
    PostTypeId,
    CASE 
        WHEN PostTypeId = 1 THEN 'Question'
        WHEN PostTypeId = 2 THEN 'Answer'
        ELSE 'Other'
    END AS [Post Type],
    OwnerUserId AS [User ID]
FROM Posts
ORDER BY CreationDate DESC

fork query

created nov 11 anonymous