| Subject | Re: [firebird-support] Select records by their position |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2007-08-16T19:48:25Z |
Magno Machado wrote:
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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Is it possible to select some records from a table based on their positions?No !
> 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)
>
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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br