Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select one row
Kenneth Herskedal wrote:
> How can I select only the first row from a table.
>
> My select statement returns several rows, but I'm only interested in the
> first row of the result set.
Hi Kenneth,
try ...where rownum = 1...
Received on Wed Nov 11 1998 - 03:10:23 CST