hi expert, i'm having following sql

SELECT E.SEQ_NO, E.SUBJECT, M.SUBMODULE_NAME, E.SEND_STATUS, E.SEND_DT, E.CREATE_DT, E.CREATE_ID FROM PR_SEND_EMAIL E, UA_SUBMODULE M
WHERE E.SUBMODULE_ID = M.ID order by E.SEQ_NO desc,E.CREATE_DT desc

this will return all record, but now looking for sql where to get record for 0-10, or 11-20, or 21-30 for pagination,

when i search there is keyword limit, offset, skip but its not support by informix, do anyone can guide me,

thanks in advance

Informix:
SELECT FIRST 10 * FROM T order by a

Informix (row numbers are filtered after order by is evaluated. SKIP clause was introduced in a v10.00.xC4 fixpack):
SELECT SKIP 20 FIRST 10 * FROM T order by c, d

For more sql statements, you can check out: sql statements