Subject | Re: Does anybody know??? |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-06-03T19:49:36Z |
--- In firebird-support@yahoogroups.com, Carlos Ortiz Quiros wrote:
.SKIP.
means how many of the first rows should be excluded, e.g. SELECT FIRST
10 SKIP 5 returns records 6 through 15, so far I'm happy to say
there's no SELECT FIRST 5 SKIP 5 STEP 2 to return records 6,8,10,12
and 14 ;o)
Set
> Thank you David an Alan, I just didn´t know the factI think they use other words, possibly TOP...LIMIT rather than FIRST..
> that First was not present in IB6, worder if present
> in further versions of IB it is present.
.SKIP.
> By the way, then anybody knows where to find theYou've already been told about the release notes, the skip part simply
> FB1.5.2 SQL syntax documentation. What does the
> skip-part-clause means.
means how many of the first rows should be excluded, e.g. SELECT FIRST
10 SKIP 5 returns records 6 through 15, so far I'm happy to say
there's no SELECT FIRST 5 SKIP 5 STEP 2 to return records 6,8,10,12
and 14 ;o)
Set