Subject | Re: Pagination Example |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-05-31T23:18:58Z |
> I am very new to java and I am working on a web app where I can showJava has very little to do with it, it is a feature of Firebird:
> only 20 regs per page, sort of VB app with Next-Prev-First-Last
> buttons.
>
> It this possible with Firebird and Java?
SELECT FIRST m SKIP n <list of columns> FROM <table> WHERE <condition>
m - number of records to fetch
n - number of records to skip before returning the first result
Note, you should add ORDER BY clause to guarantee that your rows are
always returned in the correct order.
Roman