0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT TOP 100
    Id AS [Post ID],
    Title AS [Post Title],
    Body AS [Post Content],
    CreationDate AS [Date Created],
    Score AS [Post Score],
    ViewCount AS [View Count]
FROM Posts
WHERE 
    (Title LIKE '%ageism%' OR Body LIKE '%ageism%')
    AND (Title LIKE '%software engineering%' OR Body LIKE '%software engineering%')
    AND PostTypeId = 1 -- Apenas perguntas (PostTypeId = 1 para perguntas, 2 para respostas)
ORDER BY CreationDate DESC;

fork query

edited dec 10

created dec 10 anonymous