Hello ib-support: In a web site project,I want to split the query result into Multi-pages.With Oracle ,I use the SQL statement:
SELECT * FROM
(SELECT ROWNUM rnm,a.* FROM ( SELECT * FROM customer WHERE ...... ORDER BY cus_id ) a
WHERE ROWNUM <10)
WHERE rnm >=1

How can I write the sql whit FireBird 1.02?
best regards.


---------------------------------
Do You Yahoo!?
"雅虎通网络KTV, 随时随地免费卡拉OK~~"

[Non-text portions of this message have been removed]