0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT TOP 5
    question.Id, question.Title, question.CreationDate, 
    question.Score, question.ViewCount, question.AnswerCount, 
    question.CommentCount, usr.Id AS UserId, 
    usr.Reputation, usr.DisplayName
FROM Posts question
    INNER JOIN Users usr ON question.OwnerUserId = usr.Id
WHERE
    question.PostTypeId = 1
    AND LOWER(question.Title) LIKE '%big data%'
    AND LOWER(question.Title) LIKE '%test%'
ORDER BY question.CreationDate DESC;

fork query

edited oct 30

created oct 30 jon.doe45889