By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,382 Members | 1,881 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,382 IT Pros & Developers. It's quick & easy.

FETCH ROWS IN FIREBIRD 2.0

P: n/a
I ned know how set the number of rows obtained from a interbase 2.0
query, hi have tried with instructions has fetch rows, limit, top...
but i didn't have found a correct result,
Please if somebody can help me!

(for example... i need get the rows to 5 to 10 from the sql sentence
select field1,field2 from my table)

Feb 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hello!
>I ned know how set the number of rows obtained from a interbase 2.0 query.
I'm not sure about FireBird, but with Borland (CodeGear) InterBase since
version 7.0, you can use the ROWS argument in the SELECT statement. For
instance to return rows 5 to 10:

--------
SELECT name, address, city
FROM customers
ORDER BY name
ROWS 5 TO 10
--------

If FireBird supports the same notion, then that is the answer to your
question. Check your FireBird 2.0 SQL Reference documentation for details.

Here's the link to InterBase 6.0 SQL reference, which was the starting point
to FireBird. I didn't seem to find a SQL reference specifically for FireBird
2.0.

http://www.ibphoenix.com/main.nfs?a=...=ibp_60_sqlref

Hope this helps.

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
ja***@removethis.dystopia.fi
http://www.saunalahti.fi/janij/
Feb 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.