> Is it possible to select some records from a table based on their

positions?

There is no "position" in a table, there's only a "position" in a resultset
that's
ordered.

> 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?

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