Data Extract Cloud HW1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

WITH allData AS (
    SELECT
                ROW_NUMBER() OVER (ORDER BY ViewCount Desc) AS row
                , *
    FROM        Posts
)
SELECT      *
FROM        allData
WHERE       row    >= ##StartRow:INT?50001##
AND         row    <= ##EndRow:INT?100000##
ORDER BY    row

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results