Лучший вопрос в день регистрации

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

SELECT p.Score, p.CreationDate, p.Id as [Post Link]
FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId
WHERE PostTypeId = 1 
    AND CAST(FLOOR(CAST(p.CreationDate as float)) as datetime) = CAST(FLOOR(CAST(u.CreationDate as float)) as datetime)
    AND p.CreationDate BETWEEN '08.26.2017' AND '09.01.2017'
ORDER BY
    p.Score DESC,
    p.CreationDate;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results