| Did you know ... | Search Documentation: |
| CQL: TOP N is Parametric |
You can pass the "N" is TOP N as a parameter (Subject to DBMS compatibility. This works in SQL Server 2005 and later, and PostgreSQL 9 (possibly earlier versions) and SQLite3.
N = 3,
findall(I,
{[],
se_lt_z :: [i-I], top(N), order_by([+I])},
L)