Subject Re: [firebird-support] Select records by their position
Author Alexandre Benson Smith
Magno Machado wrote:
> Is it possible to select some records from a table based on their positions?
> f.e.:
> F.e., if I want only the 1st, 2nd, 80th and 100th record from a table.
> I know the first/skip clauses, but they don't solve my problem(AFAIK)

No !

Because the records has no "fixed" position, the result set (that could
be a piece of the entire table) would be the order specified in the
ORDER BY clause, without an ORDER BY clause, the order of the records
are unpredictable.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil