0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT 
    TOP 50 -- Limits the output to the first 50 results
    Id AS [Post Link], 
    Title, 
    ViewCount, 
    CreationDate 
FROM Posts 
WHERE 
    Tags LIKE '%<java>%' -- Searches for posts tagged with Java (JVM-related)
    AND Title LIKE '%exception%' -- Searches for posts with "exception" in the title
    AND ViewCount >= 3000 -- Filters posts with at least 3000 views
    AND CreationDate BETWEEN '2022-01-01' AND '2022-12-31' -- Filters for posts created in 2022
    AND PostTypeId = 1 -- Ensures only questions are selected
ORDER BY ViewCount DESC; -- Orders results by view count (highest first)

fork query

edited nov 30

created nov 30 anonymous