Re: select only the first record

juerg.rietmann@pup.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@Yahoo.com #



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