Hi S.,

> Select first 5 from customers;
>
> This gives an error.

You didn't include a fieldlist.


select first 5 * from customer

or

select first 5 cust_no, customer from customer

will work.


Usually you'll want an ORDER BY too, unless you don't care which
records you'll receive.


Greetings,
Paul Vinkenoog