Return query-specific row number.
Something similar to "ROWNUM" in Sybase or "ROW_NUMBER()" in MS SQL. Could be used with "SELECT TOP" to mimic PostgreSQL/ MY SQL "LIMIT/ OFFSET" paginations.
28
votes
Something similar to "ROWNUM" in Sybase or "ROW_NUMBER()" in MS SQL. Could be used with "SELECT TOP" to mimic PostgreSQL/ MY SQL "LIMIT/ OFFSET" paginations.