- Notifications
You must be signed in to change notification settings - Fork689
ROWNUM
Mathias Rangel Wulff edited this pageJun 12, 2015 ·2 revisions
Has the aliasROW_NUMBER
You can receive number of result record in the recordset like in this example:
alasql('CREATE TABLE one (a INT PRIMARY KEY)');for(vari=1;i<1000;i++){alasql('INSERT INTO one VALUES (?)',[i]);};varres=alasql('SELECT * \ FROM (SELECT a, ROWNUM() AS r FROM one)\ WHERE r BETWEEN 55 AND 60');
You can try this examplein jsFiddle
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo