| Subject | Re: [firebird-support] The last records of a result set |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-06-01T21:06:40Z |
dr_bentonquest wrote:
ordered unless you specify an ordering. To get the "last" ten, reverse
the ordering and request the first 10. If you don't care about the
order, take 10 at random.
Regards,
Ann
>Sorry, I seem to have my pedantic hat on today. Result sets aren't
> I am using Firebrid 1.5.2 and need to get the last 10 records of a
> given result set. I'm sure a stored procedure is the answer, but would
> appreciate some ideas on actual code.
>
ordered unless you specify an ordering. To get the "last" ten, reverse
the ordering and request the first 10. If you don't care about the
order, take 10 at random.
Regards,
Ann