Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

last rows select

0 views
Skip to first unread message

André

unread,
May 30, 2003, 3:26:54 PM5/30/03
to
hi,

I want to get the last rows select.

André


Jeff Overcash (TeamB)

unread,
May 30, 2003, 4:18:41 PM5/30/03
to

"André" <andre...@agrosoftrs.com.br> wrote:
>hi,
>
>I want to get the last rows select.
>

In a C/S DB last rows has no meaning. First thing you have to
do is write a SQL statement that uses an Order By so you
enforce an order on the results. Then reverse that order by so
the last rows are now first. In IB 6.5 and higher now use the
ROWS keyword to restrict the number of rows you want to see.

>André
>
>

0 new messages