0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

SELECT TOP 10 Id AS [Post Id], Title, Body, ViewCount 
FROM Posts
WHERE ClosedDate IS NULL AND DATEDIFF(dd, GETDATE(), CreationDate) < 2
ORDER BY ViewCount/CAST(GETDATE()-CreationDate AS FLOAT) DESC

view current version

edited apr 4 14

created apr 4 14 Andrew T.