0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
    P.Id AS [Post Link],
    P.Title,
    P.Tags,
    P.ViewCount,
    P.AnswerCount, -- the number of undeleted answers (only present if PostTypeId = 1)
    P.Score
FROM Posts AS P
INNER JOIN PostTags AS PT ON P.Id = PT.PostId
INNER JOIN Tags AS T ON PT.TagId = T.Id
WHERE 
    T.TagName = 'security'
    AND P.PostTypeId = 1 -- 仅选择问题
    AND P.AcceptedAnswerId IS NOT NULL --AcceptedAnswerId不为空
ORDER BY P.ViewCount DESC;

fork query

edited nov 20

created nov 19 anonymous