On Tuesday, 10. July 2001 15:09, juerg(dot)rietmann(at)pup(dot)ch wrote:
> Hello there
>
> Is it possible to do a query and selecting only the first record in
> ad table ?
>
> e.g. select FIRST * from cars
SELECT * FROM cars ORDER BY <your pkey> LIMIT 1;
Without ORDER BY, there is no "first" record - any record could be
returned.
Regards,
Christof Glaser