0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

/*SELECT TOP 1000  p.* ,p2.**/
 /*p.Title, p.Id, p.Score, p.ViewCount, u.DisplayName */
/*FROM Posts p*/
/*full outer JOIN Posts p2 ON p2.ParentId = p.Id*/
/*JOIN Users u ON p.OwnerUserId = u.Id*/
/*WHERE  p.PostTypeId = 1 and p2.PostTypeId = 2 */
/*----------------------------------------------*/
/*JOIN Users u ON p.OwnerUserId = u.Id*/
/*JOIN SuggestedEdits s ON p.Id = s.PostId*/
/*JOIN Comments c ON c.PostId = p.Id*/
/*JOIN Posts p2 ON p2.ParentId = p.AcceptedAnswerId*/
/*WHERE p.PostTypeId = 1 AND p.Tags IS NOT NULL*/
/*WHERE  p.PostTypeId = 1 and p2.PostTypeId = 2 and p.Tags IS NOT NULL*/


/*FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id*/
/*JOIN SuggestedEdits s ON p.Id = s.PostId*/
/*JOIN Comments c ON c.PostId = p.Id*/
/*JOIN Posts p2 ON p2.ParentId = p.AcceptedAnswerId*/
/*WHERE p.PostTypeId = 1 AND p.Tags IS NOT NULL*/
/*WHERE  p.Tags IS NOT NULL*/

/*
union all 再试一下

SELECT TOP 10  *
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
JOIN SuggestedEdits s ON p.Id = s.PostId*/
/*FULL OUTER JOIN Posts p2 ON p2.ParentId = p.AcceptedAnswerId*/
/*WHERE p.PostTypeId = 2 AND p.Tags IS NOT NULL*/

/*

SELECT TOP 10 *
FROM Posts*/

/*--------------------*/
/*
SELECT top 200 p.Title, p.Id, p.Score, a.Score AS "Accepted Score", 
u.DisplayName AS "Asker", au.DisplayName AS "Answerer",p.AnswerCount,a.Body
  
FROM Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id
JOIN Users u ON p.OwnerUserId = u.Id
JOIN Users au ON a.OwnerUserId = au.Id
WHERE p.PostTypeId = 1
AND p.Score >= 25
and p.AcceptedAnswerId IS NOT NULL
ORDER BY p.Score DESC*/

SELECT      TOP 50000
            p.OwnerUserId                                       AS [User]
            , p.Id                                              AS [Post Id]
            , CASE WHEN p.PostTypeId = 1 THEN 'Q' ELSE 'A' END  AS [Type]
            , COALESCE (p.Title, ownr.Title)                    AS [Title]
            , p.Body
            , COALESCE (p.Tags, ownr.Tags)                      AS [Tags]
            , p.CreationDate
FROM        Posts p
LEFT JOIN   Posts ownr      ON ownr.ID = p.ParentId
WHERE       p.OwnerUserId   = ##UserId##
AND         p.PostTypeId    IN (1, 2)  -- Question, answer
ORDER BY    p.OwnerUserId DESC,  p.CreationDate

fork query

edited apr 19 20 jon.doe33551

created mar 29 20 anonymous