Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Query
select ............ where rownum < 2
Kinna Patel wrote:
> How can I write an SQL query which will return the first record in a
> recordset. Under SQL Server 7 you can use the keyword TOP but this
> does not work under Oracle.
>
> Thanks in advance
--
![]() |
![]() |