0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools

-- Fetch Java-related questions from January to June 2024
SELECT 
    Id AS PostId,
    CreationDate,
    Body,
    Title,
    PostTypeId,
    NULL AS ParentId, -- Questions don't have a parent post
    'Question' AS PostType
FROM 
    Posts
WHERE 
    PostTypeId = 1 -- Questions
    AND Tags LIKE '%<java>%' -- Java questions
    AND CreationDate BETWEEN '2024-01-01' AND '2024-11-09'

ORDER BY 
    CreationDate DESC;

fork query

edited nov 10

created nov 10 anonymous