Re: select only the first record

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

You can either use a CURSOR and FETCH only the first row, or
use LIMIT (non-standard).

And you might want to explicitly ORDER the result set,
otherwise exchange "FIRST" with "ONE-RANDOM" in your
question.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com