Database Reference
In-Depth Information
ORDER BY "id" DESC
LIMIT 2;
In this query, our
WHERE
clause plays two roles. As earlier, we specify multiple partitions
using the
IN
keyword but now we also use a range query on
id
to ensure that we get the
second page of results. This is among the most complex
WHERE
statements that are legal
in CQL without resorting to
ALLOW FILTERING
. As expected, the resulting rows com-
prise the second page: