0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT * FROM (
    SELECT 
        question.Id, 
        question.Title, 
        question.CreationDate, 
        question.Score, 
        question.ViewCount, 
        question.AnswerCount, 
        question.CommentCount, 
        usr.Id AS UserId, 
        usr.Reputation, 
        usr.DisplayName,
        ROW_NUMBER() OVER (ORDER BY question.CreationDate DESC) AS RowNum
    FROM Posts question
    INNER JOIN Users usr ON question.OwnerUserId = usr.Id
    WHERE
        question.PostTypeId = 1          -- 1 representa posts do tipo "Question"
        AND LOWER(question.Title) LIKE 'big data%'
        AND LOWER(question.Title) LIKE '%test%'
) AS OrderedQuestions
WHERE RowNum BETWEEN 11 AND 110
ORDER BY RowNum;

fork query

created oct 30 jon.doe45889