Q&A for professional and enthusiast programmers
SELECT id, CreationDate , ViewCount FROM Posts WHERE CreationDate >= 01/01/2017 -- Filtro aquellas desde el 01/07/2017 ORDER BY CreationDate -- Las ordeno ascendentemente OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY -- Obtengo las 10 primeras