Hi,

> > There is no "position" in a table, there's only a "position" in a
> > resultset
> > that's
> > ordered.
>
> Ok. So i'll rewrite my question:
> Is it possible to select some records from a resultset based on their
> positions?
> I think it's the same idea used by the first/skip clauses. Am I wrong?
>
> > > 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)
> >
> > Why not?
>
>
> Hum..
> I thought it work with a range only... F.e., if I want the 2nd, 3rd and

4th

> rows I can use "select first 3 skip 1 .............."
> But if I want the 2nd and 4th only?

Then select 2nd and 4th only.

First 2, skip 1 or so? And then First 4 skip 3.


It's a rather strange requirement though ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com