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 answers to those Java-related questions
SELECT 
    Id AS PostId,
    CreationDate,
    Body,
    NULL AS Title, -- Answers don’t have a title
    PostTypeId,
    ParentId, -- ParentId links the answer to the question
    'Answer' AS PostType
FROM 
    Posts
WHERE 
    PostTypeId = 2 -- Answers
    AND ParentId IN (
        SELECT Id 
        FROM Posts 
        WHERE PostTypeId = 1 
        AND Tags LIKE '%<java>%'
        AND CreationDate BETWEEN '2024-01-01' AND '2024-01-05'
    )
ORDER BY 
    CreationDate DESC;

fork query

edited nov 10

created nov 10 anonymous