0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

SELECT 
    TOP 1
    p.Id AS QuestionId,
    p.Title,
    p.Body,
    p.Score,
    p.ViewCount,
    p.CreationDate
FROM 
    Posts p
WHERE 
    p.PostTypeId = 1 -- Only questions
ORDER BY 
    p.ViewCount DESC; -- Sorting by score to find the highest

view current version

edited dec 3

created dec 3 jon.doe46458